Forum Discussion
Many to Many - No Duplicates?
Hey all, I'm working with a new data set that comes from Excel. It has one column for SKUs as a unique identifier. I am trying to link it to a second dataset that has SKUs but not as a unique ident...
Bear in mind that duplicates in the query editor and duplicates in the model aren't exactly the same since M is case-sensitive and DAX is not. Is it possible that you have some SKUs that differ only by case?
Try clean, trim, and upper case and then remove nulls and remove duplicates on the SKU column.
Text.Upper(Text.Trim(Text.Clean([SKU])))
Thank you Alexis, I couldn't figure it out! Yes, it was due to M being case-sensitive and DAX not, and your solution worked perfectly.