Forum Discussion
Solved
Max Date with filter / selection
Hi Everyone, I think this should be easy. The data is pretty simple, it is a table with EntDate (the day the data was entered) and Volume (the volume recorded on that day). I would like to have a...
Ive had a similar issue without any sorting or linked table issues. Im using an ALL filter in PBI to return the last yearPeriod in my data 202208. CALCULATE(max(Data[YearMonth]),all(Data[YearMonth])). Its fine until my data filtering (slicers) excludes records with that date then it refers to the max data available in my case 201908. In my eyes ALL should mean ALL. In the end, in my Transform layer I created a reference to my main data as an orphan table then took the max of the Year Month as a single record. I then used the following formula. CALCULATE(max(CM[YearMonth])) where CM is my orphan record. Again ALL should mean ALL and it doesnt inspire confidence when something as fundemental as this doesnt work properly.