Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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/
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |