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.
Hi Experts,
Hope somone could help me understand this circular dependency error. I'm running a test, the table blelow is very simple, only have two columns: ID is number, and Time is datetime. I created a calcuated column named First_Time using Calcuate function. The problem I could not understand is that why when the Firstnonblank refers to the time (datetime type) column itself, the circular dependency error would happened, but when it refers to a specific date('time'.[day]), the error disappeared.
The DAX First_Time might meaningless, but I really want to understand how Calcuate and Firstnonblank works in this situation.
Thanks in advance
Solved! Go to Solution.
HI @Anonymous,
I think this issue may related to time intelligence feature.
AFAIK, time intelligence will generate a hidden calendar table based on date/time column to expand hierarchy tree for this column.
Firstnonblank function will also loop through current table, so I think it's calculate logic may conflict with hidden calendar table generate, so power bi shows circular dependency error.
In addition, you can also take a look at below link which told about circular dependency issue:
Understanding Circular Dependencies in Tabular and PowerPivot
Regards,
Xiaoxin Sheng
HI @Anonymous,
I think this issue may related to time intelligence feature.
AFAIK, time intelligence will generate a hidden calendar table based on date/time column to expand hierarchy tree for this column.
Firstnonblank function will also loop through current table, so I think it's calculate logic may conflict with hidden calendar table generate, so power bi shows circular dependency error.
In addition, you can also take a look at below link which told about circular dependency issue:
Understanding Circular Dependencies in Tabular and PowerPivot
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |