cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karlosdsouza
Helper II
Helper II

How to define the measure which uses the evaluation context value

MyMeasure = TotalLeaversYTD / NoOfPeople * (12 / n)

 

where

 

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

1 ACCEPTED SOLUTION

Hi,

 

Try this

 

=IF(MONTH(MIN(Data[MonthName]))-3<0,12+(MONTH(MIN(Data[MonthName]))-3),MONTH(MIN(Data[MonthName]))-3)

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
sreenathv
Solution Sage
Solution Sage

Your post is not clear. Do you want the current month to be considered as n?

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)

Capture3.JPG

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

Hi,

 

Try this

 

=IF(MONTH(MIN(Data[MonthName]))-3<0,12+(MONTH(MIN(Data[MonthName]))-3),MONTH(MIN(Data[MonthName]))-3)

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors