Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sameperiod last 2 year

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's avatar
    AnthonyJoseph
    3 years ago

    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

1 Reply

  • AnthonyJoseph's avatar
    AnthonyJoseph
    Resolver III
    3 years ago

    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