Forum Discussion
Relative Date Slicer Working
I connected live data using server so and here my issue in Default relative date slicer the future is data is predicted where i just need the date to be filtered for past and present date data , i e...
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!
You can for example set the offset of years between -3 and 0, that will have the last 3 full years including the current one.
-3 to -1 will be the last three years, not including this one.
-1 to 1 would be last year, current year and next year etc.
You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/
Thank you .