Forum Discussion
SortByColumn property set to an invalid column ID
I am trying to sort my Week-Year column of my date table, by a column called "Sorting Order - Weeks". However, for this specific column I am getting the following error. "The column "Week _ Year (...
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
Most Valuable Professional
Most Valuable ProfessionalI 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/