Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PabloGiraldo
Helper IV
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

 

Capture.JPG

1 ACCEPTED SOLUTION

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

 

DataZoe_0-1612972859350.png

 

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)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

13 REPLIES 13
DataZoe
Microsoft Employee
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)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Did not work.

@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 )
)
 
DataZoe_1-1612971312340.png

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

 
 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Sorry forgot to attach screenshot

Capture.JPG

 

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

 

DataZoe_0-1612972859350.png

 

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)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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

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

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.

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

 

DataZoe_0-1612972091087.png

 

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:

 

DataZoe_1-1612972228368.png

 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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.

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

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

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.