MAX Date of what user selected

[FPP]

Hi, I have a date table with Date, Year, Month, Year-Month, Year-Month-Name.

My report has a visual where the user can select a Year and another where they can select Multiple Months.

If the user selects 2024 and then Jan, Feb, March and April I need the following:

Year-Month-Name	MyMaxDate	MyMaxMonthName
Jan 2024	Apr 30, 2024	Apr, 2024
Feb 2024	Apr 30, 2024	Apr, 2024
March 2024	Apr 30, 2024	Apr, 2024
April 2024	Apr 30, 2024	Apr, 2024

Note: My Date table has a record for every day from

1/1/2017 all the way to 12/31/2024

[Greg_Deckler · Accepted solution]

@FPP MAXX(ALLSELECTED('Dates'), [Date])