GROUP BY in PowerQuery ignores 1 specific value

[sidneyjacobs]

Hey everybody,

I'm either missing something extremely obvious, or I've come across a bug in PowerQuery.

I'm creating a table of clients, their orders and the products in those orders. While trying to use a Group By of all clients and their last orders, 1 clientnumber dissapears.

To test if I've done anything wrong, this was my debugging process:

From the current state, I filter the column clientnumber to CONTAINS '#' (the missing client). This shows me 1 line with the client and their order.

I now use the Group By function, on the column clientnumber. As aggregation I used count rows. If I filter the resulting table on clientnumber, again with CONTAINS '#' there are no entries.

To double check, I used groupby on the filtered table (so 1 row) and then if obviously works.

Am I missing something obvious? Sorry for not including screenshots/actual values, since it is confidential information.

Kind regards,

Sidney

[v-robertq-msft]

Hi,

I think you should check this official document to make sure if you have missed some important steps:

https://docs.microsoft.com/en-us/power-query/group-by

If you still have a problem, I think you can go to the Power Query community to open a new case so that experts can help you to solve this:

https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

Thank you very much!

Best Regards,

Community Support Team _Robert Qin