I start my Power BI dashboard by showing users a page that I call "Select". It's primary purpose is to allow users to use a filter that shows a series of end dates. i.e. 1st July, 7th July, 14th July, 21July... etc... you get the idea. Selecting this date Sync's the filter selection to other pages.
Having users (executives) select a new date is a bit prone to "user error"... and I'd like to be able to determine what the last available date is and perform that selection automatically.
So for useability... I return to wanting to magically (via DAX?) select the last entry in a list of dates.
You cannot use measures as slicers, and DAX are like Excel functions. They can report data, but they cannot change anything in the file like VBA could., and there is no VBA in Power BI. At this point it might be a USERVOICE request to have slicers preset to certian data based on criteria.