Solved: Custom sort column not working (Circular depency)

Anonymous · ‎03-30-2021

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?

edhans · ‎03-30-2021

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

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

edhans · ‎03-30-2021

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

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Anonymous · ‎03-30-2021

I did in Power query and worked!

thank you!

edhans · ‎03-30-2021

Excellent @Anonymous - glad I was able to assist.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Custom sort column not working (Circular depency)