Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    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_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

dkay84_PowerBIhow you do the clean in power bi?  could you please describe a bit detail?  many thanks. 

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago
    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.