topic Change Fiscal Year format in date table in DAX Commands and Tips

Change Fiscal Year format in date table

MikeGeno — Fri, 06 Oct 2023 17:56:57 GMT

I have a column in my date table for fiscal year as follows:

FiscalYear =

"FY" & YEAR('Date'[Date]) + IF(MONTH('Date'[Date]) < 4, -1)

The result is FY2023

I have tried to insert a format function a number of ways to change it show as FY23, but every time I get two digits it is not the correct year.

Thanks in advance

ThxAlot — Fri, 06 Oct 2023 19:27:52 GMT

Simple enough,

MikeGeno — Fri, 06 Oct 2023 19:38:41 GMT

Thank you! I only needed two "y"'s to get rid of the 20 and show FY23. Much appreciated