Forum Discussion
Date order
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.
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.
5 Replies
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
I did as you did but am still having issues with the sort.
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
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.The year month will sort correctly, but I need only month. Month only is still being sorted out of order.
