Forum Discussion

Ley's avatar
Ley
Helper I
6 years ago
Solved

Calculated columns with columns from different tables

Hi , I want three different meassures (3 calculated columns). Each of them is the difference of two columns (X - Y) from from different tables. Column X is in table 1 Column Y is in table 2   Re...
Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Ley , 

 

There is a good description for circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.

 

It does not allow to have two calculated columns that contain measures that are also based on that table.   As a workaround, you may try to convert these into measures instead of column.

 

You can refer to the similar case: "A circular Dependency was detected" error while creating a calculated column.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.