Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove Duplicates not working?

I have run into this issue many times and wanted to see if anyone has any feedback.  In this specific case I have 2 lists of user names.  I append the user names to a new query to have a singular lis...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

remove duplicates is a case-sensitive function. try UPPERCASE or LOWERCASE before it

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    az38  thanks for your information!  out of curiousity is it the same logic when using the Merge Queries?  For instance if I have user names "username" & "Username"  will they merge or will they not merge as they are considered unique?

     

    Thanks!

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      for DAX relationships it doesnt matter,

      for power query case seems important, see this simple test

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution

      LinkedIn

      • irobba's avatar
        irobba
        Icon for Helper I rankHelper I
        6 years ago

        Just to elaborate on this as its an issue I have run in to before as well, as previously said PowerQuery is value case sensitive whilst DAX is not. So when you use Remove Duplicates in PowerQuery, it will not consider 2 values in different cases to be duplicates, but then when you create the relationship in DAX, it will consider them to be duplicates - hence the many to many. 

         

        If you have to use the text field as a key for a relationship, trim as you have already, but then also force the case before de-duping so you'll get a result more like you are expecting and give you the relationship you want in DAX.  And as per az38's post, do the same thing prior to doing your merges in PowerQuery as well.