Forum Discussion

maurcoll's avatar
maurcoll
Icon for Helper IV rankHelper IV
2 years ago
Solved

Financial Year Title

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 ...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    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

     

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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