Forum Discussion
Solved
Simple Data Sort Problem
202307 July 2023 202308 August 2023 202309 September 2023 202310 October 2023 202311 November 2023 202312 December 2023 202401 January 2024 202402 February ...
Walt1010 , With Data I can see you should not face the issue
So if your Data is in MMMM YYYY or MMM YYYY format and sort it on YYYYMM format it should work
Try creating the column again like
Month Year = FORMAT([Date],"mmmm yyyy")
Month Year sort = FORMAT([Date],"yyyymm")or
Month Year sort = year([Date]) *100 + month([Date])
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Using DAX to create the columns as you suggested, worked! I had previously created them using M. I'm not sure why there was a difference, but I'm glad I got over the problem. Thank you!