MyMeasure = TotalLeaversYTD / NoOfPeople * (12 / n)
n is the month for which the measure is being calculated
Rest of the things I am able to create a measure however not able to figure out how to create a measure for n which can be called up for MyMeasure
Go to Solution.
Hope this helps.
Your post is not clear. Do you want the current month to be considered as n?
My PowerBI table looks like this...I am unable to create a measure YTDAttrition which gets evaluated in context of the selected month. Please refer to the above screenshot formula next to YTDAttrition
I want the filtered month no to be considered as n
for e.g. while calculating YTD % as in May, value of n should be 5-3 = 2 (2nd from Apr)
(Financial year considered as Apr to Mar)
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.