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,

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