Forum Discussion
Create Relationship
I'm tring to create the relationship between two "description", i'm 100% sure the 'description' under "masterCategory-OfficeTools' is unique. plus why 'description' and 'Category' had Sum symbol a...
In the query editor there is a remove duplicates function when you import your data from excel. Did you ever try using that?
Also in excel are you checking for dups on just the one column or the two that look highlighted?
Sometimes I run into trouble when importing excel data (non-printable characters) for whatever reason. I always do a trim and clean to remove any inadvertant characters or whitespace that may be in the cell's value in order for PBI to read it correctly.
dkay84_PowerBIhow you do the clean in power bi? could you please describe a bit detail? many thanks.
- In the query editor there is a built in function (under Transform tab I believe). Not sure if there is a DAX equivalent although there is a CLEAN function in excel.