Forum Discussion

samc_26's avatar
samc_26
Helper IV
3 years ago
Solved

Year formatting in DAX

Hi, I managed to steal this DAX to create a FY table but I want the column to show the year in the format yy/yy rather than yyyy/yyyy and i have no idea how to do this within this code, can anyone please help me with this? Thank you!

 

Financial Year New = IF(
MONTH(Date_today[Date])>=4,
YEAR(Date_today[Date]) & "/" & YEAR(Date_today[Date])+1,
YEAR(Date_today[Date])-1 & "/" & YEAR(Date_today[Date]))

 

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi samc_26 ,

     

    I'd probably do it something like this:

    Financial Year New =
VAR __todayYear = YEAR(Date_today[Date])
RETURN
IF(
    MONTH(Date_today[Date]) >= 4,
    RIGHT(__todayYear, 2) & "/" & RIGHT(__todayYear + 1, 2),
    RIGHT(__todayYear - 1, 2) & "/" & RIGHT(__todayYear, 2)
)

     

    Pete

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi samc_26 ,

     

    I'd probably do it something like this:

    Financial Year New =
VAR __todayYear = YEAR(Date_today[Date])
RETURN
IF(
    MONTH(Date_today[Date]) >= 4,
    RIGHT(__todayYear, 2) & "/" & RIGHT(__todayYear + 1, 2),
    RIGHT(__todayYear - 1, 2) & "/" & RIGHT(__todayYear, 2)
)

     

    Pete