Forum Discussion
Use Fiscal Month Names
I added a calendar with the calendar function 01/01/2015 through 12/31/2018. I want the month names in the calendar to correspond to the fiscal year though. How can I make 01 = October through 12 = September? The dates in my data that I will join to the calendar use numercial values for the fiscal year month.
Maybe you could create a month column : Month = Format(Table[Date], "MMMM")
Then create a new column called Fiscal Number = SWITCH(TRUE(), Month = "October", 1, Month = "November", 2 .... so on till Month = "September", 12). Then you can use this fiscal number for what you need.
Hope this helps!
1 Reply
Maybe you could create a month column : Month = Format(Table[Date], "MMMM")
Then create a new column called Fiscal Number = SWITCH(TRUE(), Month = "October", 1, Month = "November", 2 .... so on till Month = "September", 12). Then you can use this fiscal number for what you need.
Hope this helps!