Forum Discussion
circular dependency error
I recommend trying to create the same expression as a measure instead.
I recommend reading what Marco Russo wrote about the differences between calculated columns and measures for the best answer to your question: Calculated Columns and Measures in DAX
You're welcome. Creating a measure in place of a calculated column has worked for me as a quick fix, but it might not always be the right solution. The SQLBI guys explain how to handle circular dependencies while maintaining a calculated columns, here.
Thank you once again, this one is more helpful 👍
Dear bchager,
Column will be fine
I recommend trying to create the same expression as a measure instead.
sure, i will do that, thank you
can you please explain why this circular reference issue came with column creation
I recommend reading what Marco Russo wrote about the differences between calculated columns and measures for the best answer to your question: Calculated Columns and Measures in DAX
thank you very much , it was an enlightening experience