How to calculate measure for months -12 to -24 (based on max selected date on filter)

[ovonel]

Hi,

I have 2 measures, where depending on the date filters selected, I show:

Last 12 months:

CALCULATE

(

[Xyz] , DATESINPERIOD (  'Date'[Date] ,  MAX('Date'[Date]) ,  -12 ,  MONTH  )

)

I need to do the same, but for months -12 to -24.

I have tried, but DATEADD doesn’t seem to work with MAX…

var dat = MAX('Date'[Date])



RETURN

CALCULATE

(

    [Xyz] ,

    DATESINPERIOD(

            'Date'[Date],   

            DATEADD(dat,-12,MONTH)    ,-24,MONTH)



)

How can I make the period from -12 to  -24 ?

[amitchandak]

@ovonel , Try like

Rolling 12 till last 12 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],maxX(Sales, dateadd(Sales[Sales Date],-12,month)),-12,MONTH))