Column Sorting Error

[Mikekhel1987]

Hi All,

I'm trying to sort the month into the proper sorting but it doesn't work as I search on the internet I found out that I must create an additional column and convert the month word into month number so I've created an additional column to convert the month word into month number. After converting it into numbers I tried to sort our sales  by month number but an error occured. The error says.

"This column can't be sorted by a column that is already sorted directly or indirectly by this column"

Month Table

 Please do note that the month table is related to the sales and forecast table.

Any help will be greatly appreciated. Thank You and God Bless.

[v-jiascu-msft · Accepted solution]

Hi @Mikekhel1987,

There could be a loop. You can do it like this according to your table.

1. Add an index in the Query Editor.

 

2. Sort by another column.

Best Regards!

Dale

[Mikekhel1987]

Hi Dale,

Thank You for your help. It works just like magic. God Bless.