Forum Discussion

clarkpaul's avatar
clarkpaul
Icon for Helper I rankHelper I
1 year ago

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...
Need Help
clarkpaul's avatar
clarkpaul
Icon for Helper I rankHelper I
1 year ago

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.

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Icon for Super User rankSuper User
    1 year ago

    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