Forum Discussion
Solved
Group By in Power Query
Hello, I am working a data set that is too large to load into Power BI. To limit the data I am trying to group by. My problem is that when I group by, not all the unique email names are being br...
- Thanks everyone for you help. I found the solution by reordering my steps and doing the group by earlier in my process rather than as the last step.
Please share your complete query (the M code from advanced editor).
A sample of your data will be helpfull.
Also try to filter on the three emails you were expecting before grouping and see if they appear then. Share what happens?
My wild guess?
Powerquery is free to sort your data anyway it sees fit to process your query the fastest, so your 3 emails may not end up together. You are grouping on 2 columns, so PQ might have decided sort on Email_Sent_Date_CDT first. Could this be the reason you can't find them?
You can test this by filtering on your 3 email addressses after the group by.