Forum Discussion

Copper Contributor

Oct 06, 2021

Solved

Task Status Field

Hi, I'm using MS Project Online combined with desktop version. In the desktop version, there is a field Status in task view. This is useful when needing to filter tasks by status. For my report...

Online

Project

Paul_Mather
Oct 06, 2021
Hello Peter_MSP ,

This Task Status field is not available in Project Online, it is a Project Desktop field. You could look to replicate the calculation / create a similar task status field calculation. Here are the details on how the default Task Status field is calculated: https://support.microsoft.com/en-us/office/status-task-field-769145ac-e052-45af-a847-e5ef15778bb1

Paul

Paul_Mather

MVP

Oct 06, 2021

Hello Peter_MSP ,

This Task Status field is not available in Project Online, it is a Project Desktop field. You could look to replicate the calculation / create a similar task status field calculation. Here are the details on how the default Task Status field is calculated: https://support.microsoft.com/en-us/office/status-task-field-769145ac-e052-45af-a847-e5ef15778bb1

Paul

Peter_Eng

Copper Contributor

Oct 18, 2021

Paul,

I have followed your recommendation. If anyone else is looking for a solution, I was able to recreate the field calculation as per the conditions in your link. I did this in Power BI, as the local fields in PS Project Desktop don't connect to Power Bi dashboard.

Prasanna_Rathnaswami2330
Copper Contributor
May 23, 2022
Peter_Eng Here is the DAX function I used
Taskstate = if((TODAY() > Tasks[TaskDeliverableFinishDate] && Tasks[TaskPercentCompleted] <> 100),"Late",if(Tasks[TaskPercentCompleted]>99,"Completed", if(Tasks[TaskPercentCompleted]=0,"Not Started", "On Schedule")))
Could you help check this ?
- fish_s_nobia1111
  Copper Contributor
  Oct 25, 2022
  Prasanna_Rathnaswami2330 thank you so much, this really helped. Mine was a little different but what you gave helped me in my resolve. Thank you
  Task State = if((TODAY() > Tasks[Task Finish Date] && Tasks[Task Percent Completed] <> 100),"Late",if(Tasks[Task Percent Completed]>99,"Completed", if(Tasks[Task Percent Completed]=0,"Not Started", "On Schedule")))