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 👍