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.
When I make the relationship for Item Name to Item Name its make be to Many to many and I want Many to one but it won't let me and then my visuals are not accurate. Am I missing something because they look the same and I have not had this issues with other relationships? Please help thank you!!
1 Reply
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.
