Forum Discussion
Project percent complete
PabloGiraldo I was not clear, sorry, I was just filtering the 0% and 100% just to show it was working row by row, not that it is for row by row.
I found that there are some filters for activity id on your main table. When I used them also on the card for the % it shows the 12% overall that I think you are looking for. Please let me know if that is the case!
And that is using this measure:
Percent Complete =DIVIDE (max(DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), min(TODAY(),max(ScheduleJan21[(*)Finish])), DAY ),0),DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), MAX ( ScheduleJan21[(*)Finish]), DAY ))
PabloGiraldo I found your other thread with the PBIX. Try this meaure:
I filtered the table to be not 100% or 0% so I could see the %'s to troubleshoot.
Sorry forgot to attach screenshot
PabloGiraldo I was not clear, sorry, I was just filtering the 0% and 100% just to show it was working row by row, not that it is for row by row.
I found that there are some filters for activity id on your main table. When I used them also on the card for the % it shows the 12% overall that I think you are looking for. Please let me know if that is the case!
And that is using this measure:
Percent Complete =DIVIDE (max(DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), min(TODAY(),max(ScheduleJan21[(*)Finish])), DAY ),0),DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), MAX ( ScheduleJan21[(*)Finish]), DAY ))YES SIR!!! This worked!! thanks a lot!