Choose the latest date available in a dashboard filter

analytik ,

Check if this works for you:

• Edit you date filter and select Ranking
• Select Top = 1, 'Days' from dropdown and update the 'Ranked by' formula to MAX([Days in Date])

An alternative solution is in below article:

https://support.sisense.com/kb/en/article/calculating-values-for-the-most-recent-date

Thanks

-Hari