Forum Discussion

Vishman's avatar
Vishman
New Member
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 
    Source

    Reference link:
    Operators - PowerQuery M | Microsoft Docs

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 
    Source

Reference link:
Operators - PowerQuery M | Microsoft Docs

Regards,

Xiaoxin Sheng