Forum Discussion
Solved
GROUP BY in PowerQuery ignores 1 specific value
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 tryi...
Dear Kelly,
I'm still not quite sure why.. but after a few database loads and recreating the steps my problem went away. I guess I'm better off removing the topic since I can't reproduce the steps and pose a solution for other community members.
Thank you for reaching out though!
Sidney
I bet it's an escape character issue, with # being an escape. Before grouping, try using the Replave Values function on the Client Number column, and replace # with ~ and then group.
--Nate
Hello Nate,
That's a good suggestion. I was a little unclear however: I used # to replace the actual value (think A0505483249) This is a mix of letters and numbers, never containing an escape character.