Forum Discussion

Veles's avatar
Veles
Advocate V
9 years ago

Keep getting unique values error when making a relationship

Hi all,   I've been trying to create a relationship between two tables and keep getting the "You can't create a relationship between these two columns because one of the columns must have unique va...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Veles,

 

I think your tables may contains duplicate records(duplicate records include blank records). For you scenario, you can merge key columns of these tables and use distinct function to remove duplicate records. Then create relationships between this table and above tables.

 

Sample:

New Table= DISTINCT(UNION(ALL(TableA[Column]),ALL(TableB[Column])))

 

In addtion, you can also try to remove these duplicate records in power query.

 

Regards,

Xiaoxin Sheng