Forum Discussion
Helper IIDate slicer
Hi,
I currently have a date slicer filtered to the last 3 months date range using relative date. Is there a way where by default the report will load the data between the 3 months range and will the date picker be enabled to select previous months data as well?
As of now,
I need the highlighted data range to be enabled.
1 Reply
- amitchandak
Super User
sshiny . no.
You can create a column like this in your table and save on that
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) <= eomonth(Today(),-1) && eomonth([Date],0) >= eomonth(Today(),-3),"Last 3 month Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)or refer
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
