Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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!
And that is using this measure:
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 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:
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
@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:
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
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)
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/
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |