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?
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.