Filter out most recent date in visual?

[corbusier]

I have a few visuals where I am using a date Axis and a bunch of measures. I would like to filter out the most recent date, however I'm not sure how to do it.

I have tried this measure but it just returns the second-most recent date.

CALCULATE(data[week_date],FILTER(data,data[week_date]<>MAX(data[week_date])))

Any help would be appreciated.

[corbusier · Accepted solution]

The solution was simpler than I thought.

Column = IF(data[week_date]<MAX(data[week_date]),data[week_date],BLANK())

[corbusier]

I also saw this post, which deals with a similar problem but I would like my solution to be applicable to multiple measures at once.

https://community.powerbi.com/t5/Desktop/Last-month-data-filter-in-DAX/m-p/210850#M93071