Forum Discussion
Solved
Want Date slicer with future dates
Hello, I have one problem with date slicer. As i have future dates in check-in column and want filters based on that column. Issue i can not select future dates. Slicer display only latest date...
Are you using a calendar table?
If not create a calendar table with either Calendar (firstdate, lastdate) or Calendar auto to make one automatically based on your dataset. Use that date to apply the filters.
Here is a blog about it.Hi Shloka_Lakhani - create a new calculated column and derive future date as below
New Date = date(year([Date])+2, month([Date]), day([Date]) )
rajendraongole1
Super User
Super UserHi Shloka_Lakhani - create a new calculated column and derive future date as below
New Date = date(year([Date])+2, month([Date]), day([Date]) )