Year formatting in DAX

[samc_26]

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]))

[BA_Pete · Accepted solution]

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

[samc_26]

Genius thank you very much! 🙌