How to Default Slicer End Date to always be last date in data

[harsh.nathani]

HI @Preston,

Have a look at this video.

Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables - Query Editor Tutorial

You can also try this trick

Select latest date in Slicer

Hi @Anu, Create a measure like this to harvest the latest date from a slicer: Date Harvest Max = CALCULATE( MAX( Dates[Date] ), ALLSELECTED( Dates[Date] ) ) . and check out this resource I hope this is helpful.

Set Slicer date filter to max date in the dataset

Regards,
Harsh Nathani