Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Regards,
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |