Forum Discussion
Solved
Relation issue
Hi All, I want to add a field from a Table to Values, however I get an error 'Can't determine relationships between the fields'. I have no idea what I should be doing, can someone guide me please...
Hi Vishman,
You can create a new blank query table and use 'Query Table' name and [field name] to extract the specific field of the query table.
let Source=Table1[Name1] in SourceReference link:
Operators - PowerQuery M | Microsoft DocsRegards,
Xiaoxin Sheng
Vishman Hey Man,
You can go to power query then select that coloumn and add that a query then remove duplicate then convert it as a table and bingo . you will unique record in new table .
Final result will be
Hi Harish,
I tried your steps but I got the same result, when I tried adding the column.