Forum Discussion
Solved
Max date
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
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
1 Reply
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