• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Returning last year's data from same table

Christof

Member
Hi,
I am trying to show two figures at the same time and feel like I've tried everything and researched everything but cannot find an answer (so don't know if this is possible or not).
I want to use my slicer to pick a date range to give me total sales for that period, but then I also want another pivot to show total sales for the same period last year.
So on the attached example, it is showing Total Revenue of 2326 for 28th Feb 2019, but how can I also show that total sales for the equivalent day last year (1st march 2018) was 6011, all by using just the one slider?

Is it even possible?

Any help much appreciated.

Thanks
Chris
 

Attachments

  • Last Year equivalent.xlsx
    761.1 KB · Views: 3
Thanks again for the help :)
I feel like a whole new chapter in my life is about to begin with DAX formulas.
It's only a few months ago I had everything on sumifs!!
 
Back
Top