Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
73 | |
69 | |
36 | |
26 | |
24 |
User | Count |
---|---|
97 | |
92 | |
54 | |
45 | |
41 |