How to create relationship between these tables

[Anonymous]

Hi Everyone,

I have two tables with only the supplier names field common in both, however I am trying to join them so that I can show the Spend Value in the Product table but I couldn't. I tried to use the RELATED or RELATEDTABLE functions but It didnt wont as both table could not connect in the model (here's the message I receive when I try: "you can't create a relationship between these two colums because one of the columns must have uniques values").

Your assistance will be highly appreciated!

Supplier Table:

Supplier Name	Spend
AG Enterprises	$4500
Lenix	$6000

Product Table:

Product ID	Supplier Name	Quantity	Purchase Date
1	AG Enterprises	44	21-01-2020
2	Lenix	67	22-01-2020
3	AG Enterprises	33	27-01-2020

[az38 · Accepted solution]

Hi @Anonymous 

you can try to create a bridge calcualted table

bridge Table = DISTINCT(Supplier Table[Supplier Name])

then relate it to both of your tables

[Anonymous]

It worked perfectly! Thanks.