Forum Discussion
Date filter update after data source refreshing
I am wondering is there any way to automatically update date filters when refreshing your data source. As of right now, I filtered for year, month, but when refreshing my data source, the filte...
mithiladas02 , You need to create a column like below and use that in slicer and and save this month or last month
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA