Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Genius thank you very much! 🙌