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
