Forum Discussion
DMB90
Helper II
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 ...
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.
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.