Forum Discussion
How to create relationship between these tables
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 |
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
2 Replies
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