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 as below

 

VAR FirstFiscalMonth = 4
RETURN
    IF (
        'Calendar'[ MonthNo] >= FirstFiscalMonth,
       Calendar'[Year] + 1,
       Calendar'[Year]
    )
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

     

2 Replies

  • _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

     

  • _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