Forum Discussion
SortByColumn property set to an invalid column ID
Most Valuable ProfessionalDang it! Is the data type of the sort by column correct?
Otherwise, can you paste the DAX code of the two columns in here? Then I can simulate the issue on my end 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
I checked the data type on other columns in this table that are being used to sort, and changed it to mirror those, still same issue. I have attached the code for my date table below. I am trying to sort "Week + Year (Order) - Format: (W## - YYY)" by the column "Sorting Order - Weeks"
The DAX code for the calendar table is very long, I will break it up into a few replies
- tackytechtom
I was able to sort the columns without any errors thrown.
However, the sorting does seem a bit off:
Maybe this could indeed cause some issues:/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/