Forum Discussion
Helper IIIYear Over Year by Month
Microsoft Employee
In your scenario, your first chart is taking the general calendar, as your data is started from Nov 2015. If you analysis on Month Name level (ignoring Year), like your second chart, it will take the general calendar sort for month number, that's the reason why it started from Jan.
For your requirement, you need to create the "custom sort" column to make Nov as the first. It can be like:
custom sort =
IF (
'Table'[Month Number] >= 11,
'Table'[Month Number] - 10,
'Table'[Month Number] + 2
)
Then make the Month Name column "Sort By" above column.
Regards,
- JCBI1023
Hello v-sihou-msft,
Your column name in the picture says "month name" but your custom sort column says "month number". Do I have to create a customer month number column? How would that work? I created a custom month name column like you did:
Month Name = FORMAT ('Dates'[Date],"MMM")
- v-sihou-msft
Yes, you should have a Month Number column. You can just use MONTH() function on a Date column to get the month number.
Regards,
- JCBI1023
I just cannot figure out how to get the month number column.
