Forum Discussion

Dave_the_Automator's avatar
Dave_the_Automator
Copper Contributor
May 04, 2023
Solved

Late vs Overdue tasks in Project for the web

Hi all,    Working with P4TW and the Powerbi Project Dashboard.   In the Dashboard, there is a field called Task KPI which has values 0 to 4.  There is a corresponding Task Status field which is...
Paul_Mather's avatar
Paul_Mather
MVP
May 05, 2023

Hello Dave_the_Automator ,

This is how it is calculated in the Power BI template:

  • Late Tasks = CALCULATE(COUNTA([Task ID]),FILTER('Project Tasks',[Task KPI]=3))
  • Overdue Tasks = CALCULATE(COUNTA([Task ID]),FILTER('Project Tasks',[Task KPI]=4))
  • Task KPI = if [msdyn_progress] = 1 then 0 else if [msdyn_scheduledstart] > DateTime.LocalNow() then 1 else if [msdyn_scheduledstart] < DateTime.LocalNow() and [msdyn_scheduledend] >= DateTime.LocalNow() and [msdyn_progress] > 0 then 2 else if [msdyn_scheduledstart] < DateTime.LocalNow() and [msdyn_scheduledend] >= DateTime.LocalNow() and [msdyn_progress] = 0 then 3 else if [msdyn_scheduledend] < DateTime.LocalNow() and [msdyn_progress] < 1 then 4 else 1

Hope that helps

Paul

Dave_the_Automator's avatar
Dave_the_Automator
Copper Contributor
May 06, 2023

Paul_Mather 

 

Thanks! Totally makes sense. I have read your blogs on this topic before. Super helpful.

 

While I have you, is there a way to add a custom column to a P4TW project and report on it in Powerbi? All my research says this is a categorical no.

Resources