Recently I was asked how to only show the data for the last date in a Microsoft Power BI dataset. I immediately said “DAX”, but ended up with some complexity that was not necessary. After some rounds with DAX and M, my “aha” moment occurred. Actually, it was more my “inner data modeler” saying “Belinda…. Get With It!”
Filters… Filters is all that is needed. Watch this video and see how easy it is
If this helped, how about buying me a coffee?