Forum Discussion
Error when using a column to sort another column
I have a list of values in a filter that need to be sorted. I created a sort table: I joined it to my table: I created a new column in my data table "Location_SortB = related('Alt L...
There are no blank values. I also broke the relationship to the sort table and the data table and used lookup to get the sort values. They come across correctly but when I try to apply the sort column to the data, I get a circular dependency error.
clarkpaul , LOOKUPVALUE() function will result in a circular dependency since you might have used Location column within your search field. Try fixing using RELATED() funtion or create a Sort Column at power query level by merging the queries.
Thanks,
Jai
