Moving annual total in dax

Question

How do I calculate mat in dax for same period last year. Suppose current mat will be calculated for 2018 Aug - 2019 sep Same period last year will be calculated for 2017 Aug - 2018 sep

Do you have a working MAT for current year that you're looking to modify? If yes, take a look at PARALLELPERIOD or SAMEPERIODLASTYEAR or DATEADD or PREVIOUSYEAR — greggyb
Mat = calculate ( order (sum), datesinperiod (date[date],lastdate(date[date]),-1,yea r).now to calculate if I use 1 instead of -1, does that work — Nirmalya Roy

greggyb greggyb · Accepted Answer · 2019-09-05T16:01:53

If you have a working [MAT] like in your comment, you should be able to just wrap it in a CALCULATE with SAMEPERIODLASTYEAR. See below:

MAT =
CALCULATE (
    SUM ( 'SillyFact'[Amount] ), 
    DATESINPERIOD ( 'DimDate'[Date], LASTDATE ( 'DimDate'[Date] ), -1, YEAR )
)

MAT Prior = CALCULATE( [MAT], SAMEPERIODLASTYEAR ('DimDate'[Date] ) )

See them working below in a dummy model:

Moving annual total in dax

1 Answers