Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |