A Circular Dependency was Detected

[DMB90]

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:

[DMB90 · Accepted solution]

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.

[v-stephen-msft]

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.