Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Time Slicer based on latest available data

Hi all, I tried to find something on the forum but without results. I have a report that is publish in a premium workspace that has sales data until 31 Dec 2021. The source data of the report i...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Your best bet is a relative date slicer. We can default a date range slicer.

We can do some static selection like

 

a new column in date table

 

Month Type = Switch( True(),
eomonth([Date],0)= eomonth(max(Table[Date]),0),"Current Month" ,
Format([Date],"MMM-YYYY")
)

 

and then save slicer on current month