All courses available in-class or via remote login

Group By in Power Query

Using Group By in Power Query

September 19, 2017

Using Group By in Power Query

Group By is an excellent feature in Power Query to group related rows by a column. This is useful when you have multiple entries for related rows and you want to combine them into one row based on a common attribute value. This example will illustrate this in detail

Consider a query with sales orders for employees across different states and dates.

Rows 2 and 3 has the sales orders for Bob in WA on 9/08/2016. There might be further such rows in the query where related rows might have multiple Orders. We want to combine the data such that there is only one row for each combination of Employee, State, and Date and an Orders column which sums up the orders for related rows.

Click on the Date column and go to Transform and select Group By to bring up the Group By window. Select the Advanced option at the top and fill out the sections like below and hit OK.

Group By

 

The Query now looks like this. Bob’s orders on 09/08/2016 in WA has now been summed to 62 in the Number of Orders columns and since there were two orders for Bob, the Count Orders column reflects that.

Power Query count

 
 

Check out our Power BI courses here.

 

 

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23062 Reviews
great information, good coarse -Project Advanced Perth
Damian - Project Advanced, .
well worth doing very helpful -Project Advanced Perth
Marc - Project Advanced, .
Very clear instruction from Jenny and she was very helpful. A very enjoyable intro course to Excel and I learned many tips which will be extremely helpful at work. -Excel Beginner Perth
Dani - Excel Beginner, .
I loved the course! It was really helpful and Jenny was a great teacher :) -Excel Beginner Perth
GRACE - Excel Beginner, .
I really enjoyed this course! very useful :) -Excel Beginner Perth
Renee - Excel Beginner, .
Very informative session on introducing Power BI to people that have never used Power BI. Steven presented it in a very clear and concise manner, at a slow and gentle pace for the group to understand. Steve was able to address most of the questions that the team ask him, and for questions he do not know, he looks into and come back with answers. It shows his tenacity and dedication in educating the team. He regularly makes sure the team is on track before proceeding, making sure that people are not lost or confused. Thanks -Power BI Beginner Remote Online
Jack - Power BI Beginner, .
Good Session, Ken is very Knowledgeable and fast paced, but unable to assist anyone who falls behind. -Excel Intermediate Melbourne
Darren - Excel Intermediate, .
It was good course but I have problems with my technical so ,......I will do it again face to face. thanks Kevin -Excel Intermediate Melbourne
phuong - Excel Intermediate, .
The pace of the training was great - not too fast or slow. John is very polite and patient. -Power Point Level 1 & 2 Remote Online
Bunnary - Power Point Level 1 & 2, .
Terrific instructor and very nicely structured course -Power BI Beginner Remote Online
Henry - Power BI Beginner, .
Very helpful course. I learnt a lot of fundamental skills which will assist productivity in both PowerPoint and Office more broadly. -Power Point Level 1 & 2 Remote Online
Sean - Power Point Level 1 & 2, .
Very insight as a basic starting course, could be a little too quick if the class is not as savvy in similar software -Power BI Beginner Remote Online
Vincent - Power BI Beginner, .
informative course. Feel like i've got a good grasp of the basics. Looking forward to trying to build a few reports with our existing data. Bring on the intermediate course! Thanks. -Power BI Beginner Remote Online
Brendan - Power BI Beginner, .
Great training, very informative and the day was not boring at all! Very informative. My work will improve out of sight from this. -Excel Intermediate Melbourne
Emily - Excel Intermediate, .
Great course -Power BI Beginner Remote Online
Nathan - Power BI Beginner, .
Very informative and interesting, really enjoyed the class. Really worth the investment. Thank you Jason -Analysis & Dashboards Brisbane
Cheryl - Analysis & Dashboards, .
I think this was a good training. it was a little slow at times but this is probably because I knew more about powerpoint than I thought I did. I think it would be beneficial for me to do a more advanced training. I did pick up some good tips though. -Power Point Level 1 & 2 Remote Online
Laura - Power Point Level 1 & 2, .
Learnt some helpful tricks and tips to make processes more efficient/faster for me, as well as just general navigating/understanding different parts of Powerpoint we can use. -Power Point Level 1 & 2 Remote Online
Veronica - Power Point Level 1 & 2, .
Learnt quite a few new things which will assist in my day to day work Informative and helpful -Analysis & Dashboards Brisbane
Catherine - Analysis & Dashboards, .
Ken was wonderful at explaining everything -Excel Intermediate Melbourne
Lauren - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia