Forum Discussion
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")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
3 Replies
- SarahCoolFrequent Visitor
oops, sometimes it's more simple then I think.
Thank you very much!
- SamWiseOwl
Super User
That statement is so true for DAX...
- SamWiseOwl
Super User
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