Simple Data Sort Problem

[Walt1010]

202307	July  2023
202308	August  2023
202309	September  2023
202310	October  2023
202311	November  2023
202312	December  2023
202401	January  2024
202402	February  2024
202403	March  2024
202404	April  2024
202405	May  2024
202406	June  2024
202407	July  2024

I am getting an error in sorting by another column on a very simple case:

I have a Month Year (text) column, and a Year Month (number) column, and when I try to sort the former by the letter, I get the error message about not being allowed to have multiple values in the sort column for a value in the forth column. 

The Year Month number is just year * 100 + month.

There was a blank row that I filtered out, but otherwise the data is "clean". There are multiple rows with the same data in these columns.

Here is a sample of the (summary) data. Any suggestions would be appreciated.

[Walt1010]

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!

[amitchandak · Accepted solution]

@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