Hi all, I'm struggling with how to create a calculated field so that I can filter on the single date in my 'Due Date' dimension that is closest to being before Today().

Attached a sample packaged workbook.

I did figure out how to create the calculated field for only showing due dates that have happened (e.g. filtering out all future due dates), but for some reason the next step of honing in on the max of that isn't working for me. I created 'Max Due Date Passed', which literally just takes the max of the due dates that have passed, but it doesn't give me the single most recent date.

I did have a follow-up question - what if I want to use that max due date as a filter? Right now it automatically makes the new max value the same for all rows for everything, regardless of it's due date, but my goal would be to use that so that I can filter on only those rows that have that max due date = actual due date.

Say if I drag 'New Timeframe' into the rows and then put 'Max Due Date Passed' into the filter - it doesn't seem to filter on only the 'New Timeframe' that had the max due date as their actual due date.

Hopefully I'm making sense, I feel like there are so many due date terms that it can get a bit confusing.