12 month rolling with variables

[Richard79]

Hi, 

I have done som reaserch on how to get a calculation on 12 month rolling details. I have not found a soultion that works because of the way my date table is set up. The value i need is 12 month rolling for each month for the collum NPT and Operation hours (duration). Then i need to calculate monthly 12 month rolling 12 month NPT in % of 12 month Operating hours

[Anonymous · Accepted solution]

Hi @Richard79 

Try a measure like this :

12 Months NPT=
Var MaxDate = MAX ( Dates[Date] )
Var MinDate = CALCULATE ( MIN ( Dates[Date] ), FILTER ( ALL ( Dates ), DATEADD ( Dates[Date], 1, YEAR ) "Greaterthan" SelectedMaxDate ) )
Return
CALCULATE ( SUM ( Table[NPT] ), ALL ( Dates ), Dates[Date] "LessThanOrEqualTo" SelectedMaxDate, Dates[Date] "GreaterThanOrEqualTo" MinDate )

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.