From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Grouping data

Grouping data

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Grouping data

“

- [Instructor] Grouping allows us to aggregate a field based on another selected field. Here we see we choose to aggregate the total field based on the group field. The aggregation we see here is the sum function. Grouping increases calculation options and improves query performance but it also eliminates more granular data analysis because it removes much of the real level details. In the US Census Power BI file, let's duplicate the query population by zip code. We rename it by adding the suffix grouping to the end of the query. Now in this new query, select the zip code column by highlighting it. In the transform tab, we select group by all the way on the left hand side. We select group by zip code. We're going to call this new column max population. And it's going to return the maximum population for each zip code. We can also access advanced grouping options by selecting the advanced radio button. This allows us…

Contents