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

Power BITutorials

Learn How to Create Pivot Columns Using Power Query

1 Mins read

To simplify your data and aggregate them together we can Pivot the huge data table using Power Query Editor in Power BI. This amazing feature of Power Query has hundreds of benefits. We can use it for a data source that has too many numbers of columns and rows.

Create Pivot Columns Using Power Query Editor

Let’s take an example where we have a data table showing data Sales Quarter and multiple sales values for each quarter. We want to sum them all per quarter. This can be done easily with below-given steps.

 

Step 1: Select the column in Power Query

After you load the data in Power Query, select the column to apply the Pivot Column feature as shown in the picture below.

 BEFORE CREATING PIVOT COLUMNS

Step 2: Create Pivot Column

Once you select the column that you want to Pivot, click on the options as shown below

Transform > Pivot Column

CREATING PIVOT COLUMNS

After you click on the Pivot Column button, the Pivot Columns Window gets open. Here, you have to specify the Values Column name. In this case, the value column is the Sales column.

Also, go to the Advanced options and select the function as we have selected Sum function here and click on OK.

 

Step 3: Close & Apply

Now, you can close and apply the changes after you observe the transformations that take place in your data as shown below.

AFTER CREATING PIVOT COLUMNS

You now have your new table with a total of each sales quarter.  That’s why they call it POWER QUERY!!!

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…