Forum Discussion
Need help in Planned % Calculation
Malarvizhi_P_R You can implement this logic in DAX by calculating the total planned duration (in days) and the elapsed duration (in days), then dividing the elapsed by the total to get the planned percentage.
dax
Planned % =
VAR TodayDate = TODAY()
VAR StartDate = [Target Start]
VAR EndDate = [Target End]
VAR TotalDays = DATEDIFF(StartDate, EndDate, DAY) + 1
VAR ElapsedDays =
IF(
TodayDate < StartDate,
0,
IF(
TodayDate > EndDate,
TotalDays,
DATEDIFF(StartDate, TodayDate, DAY) + 1
)
)
RETURN
DIVIDE(ElapsedDays, TotalDays, 0)Hi Malarvizhi_P_R could you share an example of your raw data?
I've tried to recreate a dataset based on what I can tell from your image, but my results don't look anywhere close to yours.
This is how I assume your data might look like based on that image:And this is my result when I place it in a Matrix with the 0-100% Version of the Formula:
Could you provide an Excel with data similar to your specific case?
Hello KarinSzilagyi . Thank you for the input. But the output that we are getting is not working as we expected. The expected output and the output we are getting is given in the below screenshot .
Note: It is a matrix view with 2 levels/hierarchy of row values and 1 level of Column value and others are values
Expected out:
Output we got from the code
Super UserHi Malarvizhi_P_R could you share an example of your raw data?
I've tried to recreate a dataset based on what I can tell from your image, but my results don't look anywhere close to yours.
This is how I assume your data might look like based on that image:
And this is my result when I place it in a Matrix with the 0-100% Version of the Formula:
Could you provide an Excel with data similar to your specific case?