Forum Discussion
pintobean87
3 years agoFrequent Visitor
Circular dependency error
Hi all. Been reading and reading and I still don't understand how to solve this problem. I have two calculated columns that are similar, but reference two different sets of date columns (to calcu...
MFelix
Super User
3 years agoHi pintobean87 ,
Since you are making the sum of the Calendar[Ifwork day] you are getting this circular reference. Believe that the best option in this case is not to have calculated columns but have measures instead, so you should delete this columns and create the relationship and then add the calculations has measures.
Be aware that making the shift to measure may require some adjustments to the calculations.