Forum Discussion
Helper IIA Circular Dependency was Detected
I have a formula that is not pulling correctly. I have standard columns I'm pulling from until Interim(1), but I don't know how to add these new columns into my equation without erroring out. It was working fine until I added the Interim(1) and Interim(2) fields.
The equation:
I ended up restructing the formula that the data was pulling from as the two calculated columns contained different criteria. When I used one of the newly calculated columns, the formula worked.
2 Replies
Hi DMB90 ,
This is a good blog on circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.
As a workaround, try measures instead of calculated columns.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DMB90I ended up restructing the formula that the data was pulling from as the two calculated columns contained different criteria. When I used one of the newly calculated columns, the formula worked.
