The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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.
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.