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 ,
I tried building both fields at once and it worked.
I hope this is useful to others~~
new_order_color = SUMMARIZE(Fact_QTY_Cost,'Fact_QTY_Cost'[颜色数],"order",if('Fact_QTY_Cost'[颜色数]="Others",99999,CONVERT('Fact_QTY_Cost'[颜色数],INTEGER)))