Circular dependency

[Anonymous]

Hello, 

I'm working on a report and I'm facing this issue "A circular dependency has been detected: Calendar[Année-Mois], Calendar[Flag Mois-Années], Calendar [Année-Mois]. So the problem is displayed when I try to sort the column [Année-Mois] by using the column [Flag Mois-Années] below the capture : 

Here are the measures that I used. Do you have any tips? solutions? 

Calendar = CALENDAR ("01/01/2020", "12/31/2021")

Année = YEAR ('Calendar' [Date])

Trimestre = QUARTER ('Calendar' [Date])

Mois_nombre = MONTH ('Calendar' [Date])

Mois = FORMAT (DATE (2016, 'Calendar' [Month_number], 1), "MMMM")

WeekdayFlag = if (weekday ('Calendar' [Date]) = 1,0, if (weekday ('Calendar' [Date]) = 7,0,1))

Année-Mois = CONCATENATE ('Calendar' [Month], "" & 'Calendar' [Year])

Flag Mois-Année = SWITCH ('Calendar' [Year-Month], "January 2020", 1, "January 2021", 2, "February 2020", 3, "February 2021", 4, "March 2020", 5 , "March 2021", 6, "April 2020", 7, "April 2021", 8, "May 2020", 9, "May 2021", 10, "June 2020", 11, "June 2021", 12, "July 2020", 13, "July 2021", 14, "August 2020", 15, "August 2021", 16, "September 2020", 17, "September 2021", 18, "October 2020", 19, " October 2021 ", 20," November 2020 ", 21," November 2021 ", 22," December 2020 ", 23," December 2021 ", 24)

Thank you very much,
Regards, 

[Anonymous]

Hi @Anonymous ,

I found similar posts which discusses circular dependency errors, please refer to

https://community.powerbi.com/t5/Desktop/quot-A-circular-Dependency-was-detected-quot-error-while/m-p/170560

https://community.powerbi.com/t5/Desktop/Error-circular-dependency/m-p/38909

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if you have created a new column say Column B, using column A. Then you can not mark it as sort column of A 

Column C = [Column A]

Column B = <logic to sort using Column A>

Now you can mark Column B as Sort of Column C and use Column C.

Refer to my video for this https://www.youtube.com/watch?v=KK1zu4MBb-c