Forum Discussion

SarahCool's avatar
SarahCool
Frequent Visitor
2 years ago
Solved

Fiscal year month name format

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

3 Replies