Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |