I have a column that I need to sort in a specific order.
I created a calculated column for indexing with the following Dax code.
DepartmentID =
VAR indexNo = ‘Account Schedule’[Dept.]
Return
Switch(indexNo,
“New”, 1,
“Used”,2,
“Systems”,3,
“Service”,4,
“Parts”,5,
“Rental”,6,
“Delivery”,7
)
When I go to the column that I want sorted, I select the column and then click on the sort by column icon and select the new calculated column “Departmentid”. I immediately get a circular reference error. What am I missing.?