Sort by another column error in calendar table

Hi Johnners ,

I can't open any onedrive files from external sources due to internal company security policies. So I can only give you some advice.

First I think you may ensure No Concurrent Operations. Make sure there are no other operations being performed on the Data Model at the same time. This includes data refreshes, calculations, or other sorts being applied. Wait for any such operations to complete before attempting to sort again.
If your Data Model is particularly large or complex, it might be taking longer to process operations. Consider optimizing your Data Model by removing unnecessary columns or rows, or by simplifying calculations.
And please ensure that there are no circular dependencies or complex relationships that might be causing the Data Model to lock up during operations. Simplify relationships if possible.
If none of the above suggestions solve the problem, sometimes, simply restarting the PowerPivot model or Excel can resolve issues related to stuck operations. The PowerPivot environment can be reset by closing the Excel workbook and reopening it.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.