Forum Discussion
Solved
Creating a Measure based on another Measure and spread across a Time Frame
Hi...I'm even struggling to formulate the question to be honest. I have a Measure that counts rows depending on the content of a specific cell e.g. Overdue, On Target, Not Required etc. No probl...
Please consider this solution and leave kudos
Create a calendar table with a list of dates and a month offset column.
With +1 for next month, 0 for the current month, -1 for last month, -2 for the month before and and so on.
Build a one to many relationship between the calendar date and your table date.
Then create measure to calculate your target% factor that you can apply to your totals.
Target % =
VAR maxoffset = MAX('Calendar'[MonthOffset])
RETURN
SWITCH (
TRUE (),
maxoffset =-0,1,
maxoffset =-1,0.9,
maxoffset =-2,0.8,
maxoffset =-3,0.7,
maxoffset =-4,0.6,
maxoffset =-5,0.5,
maxoffset =-6,0.4,
BLANK()
)
That looks interesting.....I will give that a try.
Thanks