Relation issue

[Vishman]

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? I am very new to Power BI.

Thanks,

Vishal  

[Anonymous · Accepted solution]

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

[HarishKM]

@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 

[Vishman]

Hi Harish,

I tried your steps but I got the same result, when I tried adding the column.

[Jihwan_Kim]

Hi, @Vishman 

If it is OK with you, please share your sample pbix file's link here.

Then I can try to look into your problem.

Thanks.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.