Forum Discussion
Solved
Yet another Sort by another Column error.
I've done research but so many issues out there that are not the same. This is my last resort... I have a column: Day of Week and I have a column that I built in Power Query for the sorting. (Con...
I had to refresh the data and then quit Power BI Desktop and reload it up again and then it allowed me. It must have been a caching issue.
My table itself of course has lots of other columns and there are lots of Mondays and Tuesdays, etc. and the "DayNum" column is in the same table. So I don't have a small table at all. I guess I could add one but it seems overkill just to sort one column.
Small table with 9 rows is very far from overkilling. It will solve the issue , and this is how pbi's engine like to work 🤓