Forum Discussion
circular dependency error
Hi, I tried to create a New Column as shown in screenshot but got an error message as displayed ; busdetails = table in which am trying to create new column minfarekm = measure for cal...
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 👍
Thank you once again, this one is more helpful 👍