Forum Discussion
Create custom column in one table looking on other table
Hello. I am new in Power Bi I have two tables (Table_A and Table_B) with many-to-many relations by “fk_id” fields. The “id” is the primary key in Table_B. I want to create a custom field “id” in Ta...
Thanx a lot, but I got the problem after the first step -
Table.NestedJoin(Table_A, {"fk_id"}, Table_B, {"fk_id"}, "Table_B", JoinKind.Inner)After this, I have error msg - "Expression.Error: A cyclic reference was encountered during evaluation."
Can you explain it?
It is working for me. Can you share your PBIX file or all source queries.