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 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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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