Date order

[Tripb44]

I am having an issue with date month sort.  I have a date table with month number.  I have ordered the date table to sort on date number but am still getting the below output.  

[V-lianl-msft · Accepted solution]

Hi @Tripb44 ,

Please create a new column like below:

Year-month = YEAR('Table'[Date])*100+MONTH('Table'[Date])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tripb44]

The year month will sort correctly, but I need only month.  Month only is still being sorted out of order. 

[amitchandak]

@Tripb44 , Seem like you have a month column,  have you created s month sort column for that and marked as sort column

Month = FORMAT([Date],"mmmm")
Month sort = FORMAT([Date],"mm")

mark Month sort  as the sort column for month

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c

[Tripb44]

I did as you did but am still having issues with the sort.  

[amitchandak]

@Tripb44 , I think still sort column is not correctly set, make sure table is also correct.

refer my video

How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c