Circular dependency
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'[Mois_nombre],1),"MMMM") WeekdayFlag = if(weekday('Calendar'[Date]) = 1,0,if(weekday('Calendar'[Date])=7,0,1)) Année-Mois = CONCATENATE('Calendar'[Mois]," "&'Calendar'[Année]) Flag Month-Year = 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,
