NEW! FREE 90 Minutes Excel VBA Course for Beginners! Watch now 

Power BITutorials

Read How to Group Rows And Get Counts Using Power Query

1 Mins read

Power Query allows you to group rows and get the counts of each group very easily.

Group Rows And Get Counts By Power Query

Let’s go through the steps in detail.

 

Step 1: Select the column in Power Query

To group rows, we first need to select the column from which we want to group the data. In the picture shown below, we are grouping the sales Qtr data i.e. Q1, Q2, Q3, and Q4.

BEFORE GROUPING ROWS

Step 2: Grouping the Rows

To group the rows together we have to go to

Transform tab > Group By option

GROUPING ROWS

A group by window gets open after you click on the Group By option. Here you have to specify the column to group by. In this case, we have selected the Qtr column. Also, select the new column name where you get the count of the group by column if you select the Count Rows operation and click OK.

Step 3: Click Close &Apply from the Home tab

Click on the Close & Apply button after you get the desired output as shown below.

 

GROUPED ROWS BY COUNTS

You can learn more : 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…