Forum Discussion
Solved
Circular dependency detected while sorting a column
Hi, I have a month_name column which I need to sort as Jan, Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec. For that I have created calculated column to get month numbers from month_name as below: ...
AshDil , Create a new column
Month name 1= 'Table'[Month Name]
Sort month 1 on MonthNum and use that in visual
refer if needed
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
AshDil , Create a new column
Month name 1= 'Table'[Month Name]
Sort month 1 on MonthNum and use that in visual
refer if needed
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Hi amitchandak ,
Hope you are well.
I'm having the same problem. Im created the below table based on the fact table,
ColorNumber_OrderTab = DISTINCT(Fact_QTY_Cost[colornum])
,then I created a logic column:
new_order = IF('ColorNumber_OrderTab'[ColorNum_old]="Others",99999,CONVERT('ColorNumber_OrderTab'[ColorNum_old],INTEGER)).
I get an error when I want the old fields to be sorted by the new_order field
So confused.
BR,
Soldier