Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 : 

 

calendar.PNG

 

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, 

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.