Financial Year Title

[maurcoll]

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

VAR FirstFiscalMonth = 4

RETURN

    IF (

        'Calendar'[ MonthNo] >= FirstFiscalMonth,

       Calendar'[Year] + 1,

       Calendar'[Year]

    )

[_AAndrade]

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

[_AAndrade · Accepted 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