Sameperiod last 2 year

[Anonymous]

Hi.

I don't know how to create a measure to compare this year with 2 years ago.
To compare with last year I have used SAMEPERIODLASTYEAR and it works well.

Tks.

Daniel Kataoka.

[AnthonyJoseph · Accepted solution]

Hi @Anonymous  
You can use parallelperiod function and a calendar table...

Last two years prior =
    CALCULATE (
        SUM ( Table[column_name] ),
        PARALLELPERIOD ( 'Calendar'[Date], -24, MONTH )

Hope this helps!

Thanks,

AnthonyJoseph