Forum Discussion

samc_26's avatar
samc_26
Icon for Helper IV rankHelper 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 pl...
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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper 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

  • samc_26's avatar
    samc_26
    Icon for Helper IV rankHelper IV
    3 years ago

    Genius thank you very much! ğŸ™Œ