Forum Discussion

Richard79's avatar
Richard79
Regular Visitor
5 years ago
Solved

12 month rolling with variables

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.