From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Group and aggregate rows

Group and aggregate rows - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Group and aggregate rows

“

- [Instructor] In this sub lesson, we are going to group and aggregate rows. In Power Query, you can group values in various rows into a single value by grouping the rows according to the values in one or more columns. You can choose from two types of grouping operations, column groupings, and row groupings. We can see here in the Microsoft documentation that there are a number of different column operations. So we've got sum, average, median, min, max, percentile, and count distinct values. These are all column operations. And then finally down below, we have three different types of row operations: we have count rows, count distinct rows, and all rows. So let's go to the Power BI desktop and demo some of these different operations. All right, so let's go ahead and group based on country and products. So I'm going to do is click on country and product, hold the two of those down and then I'm going to find the group by button off the home tab in the ribbon here. So I'm going to click…

Contents