Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
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 |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |