Forum Discussion

PabloGiraldo's avatar
PabloGiraldo
Helper IV
5 years ago
Solved

Project percent complete

I have a table with activities and dates from a construction schedule. Trying to find a way to get percent complete from the dates. Wanting to put the 12% compelte as shown below on a card. Thank you...
Need Help
  • DataZoe's avatar
    DataZoe
    5 years ago

    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's avatar
PabloGiraldo
Helper IV
5 years ago

Sorry forgot to attach screenshot

 

DataZoe's avatar
DataZoe
Microsoft Employee
5 years ago

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's avatar
    PabloGiraldo
    Helper IV
    5 years ago

    YES SIR!!! This worked!! thanks a lot!