Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Go easy, this is my first ever post!
I need to be able to calculated expected task completion percentage based on TODAY. Eg on Day 3 of a 10 day task, it should be 30% complete in theory. I need a fomula that calculates the current expected completion that changes on a day to day basis? Once I have this I can then compare with actual completion and add to my RAG rating.
Many thanks
Solved! Go to Solution.
Hi @Wharfey ,
You can create column like DAX below.
expected_completion %=DIVIDE(DATEDIFF( [start_date], TODAY(), DAY), DATEDIFF( [start_date], [finish_date], DAY))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Wharfey , Welcome to Power BI Community!
You want something like below Screen shot? if yes so use the below Measure and set it data format to %.
Hi Tahreem
This is the kind of table view I'm after (below) so essentially all I need is a formula to calculate column E based on the TODAY() function that counts back to the start date and calculates what the percentage completion should be as of the current date. I will then use DAX to determine the Task_Health rating.
thanks again.
Hi @Wharfey ,
You can create column like DAX below.
expected_completion %=DIVIDE(DATEDIFF( [start_date], TODAY(), DAY), DATEDIFF( [start_date], [finish_date], DAY))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |