Fiscal year month name format

[SarahCool]

Hi

I have created a date table with fiscal year and fiscal month.

This is working well. 

Our fiscal year is from april to march, so month number 1 = april, number 2 = may...

So now I want to format the month number to "mmm", but it's giving Jan for every row.

"FiscalYear",               IF(MONTH([Date]) < 4,YEAR([Date])-1,YEAR([Date])),
"FiscalMonth",              IF(MONTH([Date])-3 < 1, MONTH([Date])-3+12,MONTH([Date])-3),
"FiscalMonthName_short",    FORMAT(IF(MONTH([Date])-3 < 1, MONTH([Date])-3+12,MONTH([Date])-3),"mmm")

[SarahCool]

oops, sometimes it's more simple then I think.

Thank you very much!

[SamWiseOwl]

That statement is so true for DAX...

[SamWiseOwl · Accepted solution]

Hi @SarahCool 

Won't the month name stay the same?

Format([Date], "mmm")

We have a full bit of script here for CalendarAuto and how it works including Financial month name etc
https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm