Forum Discussion
Solved
Avoiding a circular dependency when having a calculated column that references the other table
I have these two tables. Now I've added a calculated column to the Order table (see dax below). The idea is that this is a best estimate of which call belongs to which order. This works fine but now...
Now I've undertand.
You have to create a CallID in the two table. For the table Calls, the CallID will be the primary key, and in the Order table the CallID will be the foreing key.
In the Calls table, create a CallID like:
CallID = CONCATENATE(callDate, Customer Phone)
and in the Order table:
CallID = CONCATENATE(dateKey, Phone)
After thar, you can create the relationship.
Hi aukev
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie