Hi all,
I am trying to figure out how to calculate a dynamic year on year calculation. I am using the following calculation options:
Total Sales SamePeriodLastYear =
CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR( ( 'Date'[Date] ) ))
To calculate sales based on a period (month/quarter/year)
Total Sales PY =
CALCULATE ( [Total Sales], DATEADD ( 'Date'[Date], -364, DAY ) )
To calculate sales based on the same day in the same ISO week (tuesday 08-06-2021 vs tuesday 09-06-2020)
These calculations are indeed dynamic, a user can select a different period by using a slicer which is a dropdown. Here the user can select another year, week or whatever they want. But the problem is that it is always a 1 year comparison.
I want to create another dropdown slicer where the user can select a year which then the calculations use for the comparison. So for example:
- User selects Year 2021 in slicer A which the user wants to see the data from.
- User selects Year 2017 in slicer B where the comparison will be made.
- Result = Year 2021 will be compared with Year 2017 for all measures which uses the above.
I have seen this article which is really usefull and does a bit of what I want to create: Dax Pattersn | Comparing different time periods . But I also want to use the date (year/month/week) on the x axis. Which is not possible with this solution. I have the exact same setup as which is shown in the article.
Please could someone help me out with this? If you need more information please let me know.
