Forum Discussion
Relationships
I am in need of some help. I think I am doing this right but maybe I am missing somehting. I have two tables. CreditMemoLine and Item. I am trying to make the relation for Item Name to Item name. ...
You are getting this issue because you have duplicate values in both tables (including blank values). Either you will need to create an intermediate table that only has unique values, or you will need to go back to the data source / power query and clean up your data so that there's unique values in at least one item column in the table.