Dynamic Time Slicer based on latest available data

[Anonymous]

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 is a SnowFlake DB where the data is ingested every month. 

On current state the Time slicer is seted as  1/1/2019-31/12/2021.

How can the slicer can switch to 1/1/2019-31/01/2022 when the new data is ingested and available? I dont want to use Relative Date Filter.

Thank you

[amitchandak]

@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