Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom sort column not working (Circular depency)

Hi all,

 

I create the custom column below:

 

When I try to sort the column "Market" by the custom column "Market sort" I get the error:

 

 

 

Any idea how to solve this issue?

 

 

 

 

Need Help
  • edhans's avatar
    edhans
    5 years ago

    Yes - put that sort column in your source data or Power Query. Avoid calculated columns. This is one of a dozen reasons why. ğŸ˜Š

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    Yes - put that sort column in your source data or Power Query. Avoid calculated columns. This is one of a dozen reasons why. ğŸ˜Š

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I did in Power query and worked!

      thank you!

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        Excellent Anonymous - glad I was able to assist.