Sort month name by month number column not working

[gili_koren35]

I created a month number column based on a date column.
I then created a month name column using a switch function based on the month number column.
But when I want to sort the month name column by the month number column I get the following error:

I checked using DISTINCTCOUNT and for every month number there is one month name, and vice versa, so that's not the problem.
what can I do?

[Anonymous · Accepted solution]

Hi @gili_koren35 

Can you show how your month number column and month name column look like currently? 

Anyway you can refer to the following blog to create the month number column and month name column from the date column directly with FORMAT function. If the table has dates of multiple years, formatting them into a YearMonth format will be better, otherwise you may experience the same error. 

Generate Year and Month Combinations in Power BI Report using DAX - RADACAD

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Arul]

@gili_koren35 ,

Check that the month number column has unique values for each month. If there are duplicate month numbers for different months, Power BI will not be able to sort the months correctly.