Max date

[NewbieJono]

hello, how would i bring back the max date in a table then show the fiscal year from that date from the date table.

The relationship is set.

The max date in the table is 01/04/2024. i would like to display it as 2024-25

[_AAndrade · Accepted solution]

Hi @NewbieJono,

Here is my solution:

On my data set my max calendar date is 31/12/2028.

VAR _MaxDate = CALCULATE( MAX (d_Calendar[Date]), ALL(d_Calendar))
VAR _Result = 
    YEAR(_MaxDate) & "-" & RIGHT( YEAR(_MaxDate) + 1, 2)
RETURN
    _Result