Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago

Year on Year Difference Problems

Hi there,    I've been working on this problem for a while now, and when I think its solved, it turns out its not.     I'm trying to show Year on Year Differences. You can see above, howev...
Need Help
Show and Tell
Tips and Tricks
EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago

Hi kentyler ,

 

The data is already set up with the Years stacked. 

 

Hi VipulToshniwal ,

 

I have tried SAMPERIODLASTYEAR but it just comes up with the same result. 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    6 years ago

    EpicTriffid 

     

    Have you tried DATEADD? something along the lines of:
    Measure for last year = CALCULATE([Measure], DATEADD(date[date], -1, YEAR))

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi EpicTriffid,

    Could you please tell us if your question has been resolved. If so, in order to close the thread, please kindly mark helpful replies as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    If it didn't solve your problem, you could try to inform me more details information(such as your sample data), then I will help you more correctly.


    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.