Forum Discussion
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]) )
2 Replies
- SamWiseOwl
Super User
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. - rajendraongole1
Hi Shloka_Lakhani - create a new calculated column and derive future date as below
New Date = date(year([Date])+2, month([Date]), day([Date]) )