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...

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

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")))
Peter_MSP
Copper Contributor
Oct 07, 2021
Paul,

Thank you for your response. I suspected that this field is not there, but I hoped I just could not find it. I will look into your suggestion and how I can implement it either through Power BI DAX or within Enterprise Fields in MS Project Online.

Peter

Resources