Group By Power Query Not Working Properly

[Anonymous]

Hi,

I am using Group By in Power Query and it is not working properly. Before using Group By, I have some duplicates of 2 and 3. After using Group By on multiple columns, it has now become 2. However, I thought Group By would've "removed" the duplicates?

This is what I set on my Group By function.

And this is what I got when I apply the query. (note that the "No Date Available" is just me replacing some values with the text and the group by clause was used before this).

Theoretically, the first two column would be condensed into one with PurchaseDate 5/15/2014 and UseDate 8/28/2014. But it's not doing so. Besides that, when I filter the number of the first two rows in Power Query, I get only 1 line, but it is not right as the UseDate should be 8/28/2014 instead of NoDateAvailable.

Anyone knows what's wrong with this?

Thanks!

Daren

[Anonymous]

Hi Darentengdrake,

please tell me how you standardized and solved groupby issue. in power query to your case

[az38]

Hi @Anonymous 

are you sure its exactly the same items?

did you try trim it before grouping?

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

[Anonymous]

Hi @az38

Although I didn't trim them, but I believe they should be the same because I did a count for duplicates and sorted them ascending. If the count is 2 it means the first two rows of the sorted table would be the same.

Daren

[Anonymous · Accepted solution]

I found out what the problem was. In Power Query, uppercased and lowercased letters are considered to be different, however, in Power BI, there are the same. That's why it appeared in Power BI table view as duplicates and group by didn't work on Power Query. After standardizing them, it worked correctly.

Thanks.

Daren