Forum Discussion
Nihed
Helper III
Helper IIILast month
Hello, I have date table, then I create a new column call Month Name using Month Name = FORMAT('Date'[Date],"MMMM") And I have Month Number for sorting this month name become a proper sorting. I...
Hi Nihed ，
If the Month Number column is of text type, the September will be the largest as you described.
Change the Month Number data type to Whole number, it will be sorted numerically from smallest to largest.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
v-yanjiang-msft
Community Support
Community SupportHi Nihed ，
If the Month Number column is of text type, the September will be the largest as you described.
Change the Month Number data type to Whole number, it will be sorted numerically from smallest to largest.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.