Forum Discussion
Rolling 12 months calculation
I would like to create a column that takes TRUE for all those values that are returned within the rolling months as of the previous month. So for example, we are in August 2018, I would need the colu...
Hi Akshaya,
As a general solution, you can create a measure using this pattern:
VAR Previous_Month =
EDATE ( MAX ( Table[Date] ), -1 )
VARPrevious_12_Month =
EDATE ( MAX ( Table[Date] ), -13 )
RETURNResult =
CALCULATE (
Your_Aggregation_Here,
FILTER (
Table,
Table[Date] >= Previous_Month
&& Table[Date] <= Previous_12_Month
)
)
Regards,
Jimmy Tao
Thank you. So the part "your_aggregation_here" is the variable name that I would create right?