Return max selected date

[JustinM]

Hi

I'm trying to return the maximum selected date in order to do a number of calculations based on periods before the  maximum selected date.

Inception Date	Id Count
Jan-21	10
Feb-21	12
Mar-21	8
Apr-21	10
May-21	5
Jun-21	6
Jul-21	10
Aug-21	15
Sep-21	20
Oct-21	25
Nov-21	12
Dec-21	15
Jan-22	12

So if for example the user selects months up to March 2021 the formula would return March 2021 as max month

I created the following variable:

=Date(Max([Inception Date.autoCalendar.YearMonth]), 'YYYY-MMM')

However it returns Jan 2022 regardless of the months selected.

Any help would be appreciated

[JustinM]

Any Ideas?