Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Time intelligence variations with time slicer

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!

Need Help

1 Reply

  • Villezekeviking's avatar
    Villezekeviking
    Most Valuable Professional
    2 years ago

    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/