cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## 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!

2/10/20 minus 8/24/20 = 169 days

7/4/24 minus  8/24/20 = 1410 days

169/1410 = 12% complete

1 ACCEPTED SOLUTION
Microsoft Employee

@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 )
)

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

13 REPLIES 13
Microsoft Employee

@PabloGiraldo You can try this measure:

Percent Complete =
DIVIDE (
DATEDIFF ( MIN ( 'Table'[Start Date] ), TODAY (), DAY ),
DATEDIFF ( MIN ( 'Table'[Start Date] ), MAX ( 'Table'[End Date] ), DAY )
)

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Helper IV

Did not work.

Microsoft Employee

@PabloGiraldo I found your other thread with the PBIX.  Try this meaure:

Percent Complete =
DIVIDE (
max(DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), min(TODAY(),max(ScheduleJan21[(*)Finish])), DAY ),0),
DATEDIFF ( MIN ( ScheduleJan21[(*)Start] ), MAX ( ScheduleJan21[(*)Finish]), DAY )
)

I filtered the table to be not 100% or 0% so I could see the %'s to troubleshoot.

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Helper IV

Sorry forgot to attach screenshot

Microsoft Employee

@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 )
)

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Helper IV

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

Helper IV

If i do what you did here, i will get % complete for some activities. Not exactly what i need. Below is used your measure above and filtered by Project Start (8/24/20) and Final Completion (7/4/24) and they are both blank bc one is a Start milestone and the other is a Finish milestone. Meaning there will only be one date (either Start or Finish).

Helper IV

So i am trying to find the percent complete for the entire job based on today's date. I need to find a way to subract Today's date minus 8/24/20 and divide by 7/4/2024 minus 8/24/20.

Microsoft Employee

@PabloGiraldo I am showing your minium on the start date is 1/1/2020 in your data, not 8/24/2020

Which is why it's coming up with 24.67%.

If I fitler the start date to 8/24/2020 then it comes up with the % you are looking for:

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Helper IV

Do you mind sharing the pbix file for what you did here with the filter? I might have to make this work. I was trying to get a measure to throw on a card but cant seem to make it work the way i wanted. It would also help me for the other cards i already have on the pbix.

Microsoft Employee

Sure, here is your pbix file with my changes. I hope it helps @PabloGiraldo

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Microsoft Employee

@PabloGiraldo Can you provide more details on how you have set up your Power BI file and what you tried?

Respectfully,
Zoe Douglas (DataZoe)

See my reports and blog at https://www.datazoepowerbi.com/

Helper IV

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.