SAMEPERIODLASTYEAR over multiple year

[pnem]

Hello
I would like to know if is there a function that resembles SAMEPERIODLASTYEAR but that can be expanded to more than one year back? Like the average of a monthly value for the same month the last five years?
Thanks!

[Uspace87 · Accepted solution]

@pnem 

you can use DATEADD, just change the number of intervals you want to go back

Measure = CALCULATE(

    [Sales amt],

   DATEADD(Date_Table[Date],-2,YEAR

))

[pnem]

Thanks!