Forum Discussion
Solved
Calculate Two Columns - Subtracting
Need a bit of help this morning on a calculated column I'm working on. I'm recieving the error message A Circular Dependency was detected Column A first calculated revenue with the forumula below...
Your Computed Costs measure looks odd to me. Can you simplify it to this?
Computed Costs = ( 'Revenue'[October Billable Hours] * ' Revenue'[payRate] ) + 'Revenue'[Cost Burden]
Yep that worked, by simplifying it. that gives me the same output for the Computed Costs
Great. If you use that simplification instead, I don't think you'll get the circular reference error.
That did it thank you!