Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
@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