Forum Discussion
Relationships Issue
Hi All
I have an issue which I can't seem to figure out what is causing it.
I have pulled in two tables of customer related data of which a common relationship is the part number. I pulled out a list of part numbers and created a unique table (all duplicates removed), so I can then create a one to many relationships from the unique part number list to the customer list.
When I try to create a relationship from the unique part number talbe to the customer detail table, it tells me I can't create a relationship because I must have unique values and I'm 100% positive my part number table is unique values. Both tables show the part numbers are set to text also. Any idea how to fix this?
18 Replies
Many times this is caused by capitalization issues.
emma313823 if you removed the duplicates in power query, it sees different cases of the same value as different values
best thing to do is to standardize everything into one case, then remove duplicates
however i think null or blank values can also create issues so pad them with a default value like na or unknown
The list of unique part numbers is in excel and I used 'get data' for this. This spreadsheet is updated regularly, so it is easier to have the spreadsheet get updated then refresh the dashboard.
Hi - trying to use your suggestions, however it shows the following...any thoughts? Can't sseem to get it to work
sorry one more thing...I had to fix what you showed as PARTS NUMBER to Part Number - there was no 's' in part.
