Time intelligence variations with time slicer

[Anonymous]

Hi everyone!

I need to be able to calculate variations in sales quantity based on a date filter. For example, if I have selected a month in the filter, it should show the variation compared to the previous month. If a year is selected, it should display the variation from the previous year. Additionally, if a day is selected in the filter, it should show the variation from the previous day, and if a week is selected, it should show the variation from the previous week—all based on the same filter. In other words, the "-1" period relative to what is filtered.

Does anyone know how to achieve this?

Thank you very much!

[Villezekeviking]

You can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!

I would create a measure that runs a switch on a "SelectedValue" in your filter.

If you've selected a year, it runs the offset on the year-column etc.

You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/