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.
Hi
I have created a column in my date table for fiscal/financial year. I want the label to show as 22/23 etc. at the minute it is only showing 2023. Is there a way of doing this please. Calculation as below
Solved! Go to Solution.
Hi @maurcoll,
Please try this code:
VAR FirstFiscalMonth = 4
VAR FicalYear =
IF (
'Calendar'[ MonthNo] >= FirstFiscalMonth,
RIGHT('Calendar'[Year],2) &"/"& RIGHT('Calendar'[Year] + 1,2),
RIGHT('Calendar'[Year]-1,2) &"/"& RIGHT('Calendar'[Year],2)
)
RETURN
FicalYear
Proud to be a Super User!
Hi @maurcoll,
Can you tell me if my message solved your problem? If so, could you mark my message as the answer to this problem?
I'd be very grateful. Thank you very much
Proud to be a Super User!
Hi @maurcoll,
Please try this code:
VAR FirstFiscalMonth = 4
VAR FicalYear =
IF (
'Calendar'[ MonthNo] >= FirstFiscalMonth,
RIGHT('Calendar'[Year],2) &"/"& RIGHT('Calendar'[Year] + 1,2),
RIGHT('Calendar'[Year]-1,2) &"/"& RIGHT('Calendar'[Year],2)
)
RETURN
FicalYear
Proud to be a Super User!
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |