The first column works as expected but unfortunately, when I try to execute the second column, I get the following error:
"A circular dependency was detected: Training_Req[TimeCost], Training_Req[ExpCost], Training_Req[TimeCost]."
I'm not sure where this circular dependency is being created... could anyone help please? I have tried looking at various solutions but am at a bit of a loss on what I can do. I would share the template file or data but unfortunately this is protected information that I cannot share.
In your case, Power BI does not allow to have two calculated columns that contain measures that are also based on that table. In order to understand why, you'd need a better understanding of what's going on under the hood.
In order to get around it, you should try turning these into measures that reference your calcllated columns.
Community Support Team _ Frank If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Both formulas seem to work fine and whatever I choose in the first column works. However, when I open the second column to add information in, I get the following error:
A circular dependency was detected: Table_C[TimeCost], Table_C[ExpCost], Table_C[TimeCost].
I know a circular dependency is one depending on another which then makes it difficult to manage but in neither of these columns do I reference TimeCost or ExpCost so I don't see where the circular reference is.