Power BITutorials

Top 3 Steps to Append Queries Using Power Query

1 Mins read
SALES DATA FOR 2015 & 2016

You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the years 2015 and 2016. We want to combine these two data tables together. Using 3 quick and easy steps you can append queries using power query.

Steps to Append Queries With Power Query

Open the power query editor, and follow below 3 steps and append queries in excel. 

Now let’s check each step to perform this task.

Sales Data

Step 1: Append Queries as New

To combine the above data tables, you need to use the Append Queries feature. To use this feature click on-

Home  >  Combine  >  Append Queries  >  Append Queries as New

APPEND QUERIES AS NEW

Step 2: Choose Tables for Appending

When you click on Append Queries as New option, an Append window gets open that allows you to choose the data tables from Power Query. First, you need to specify how many tables you want to append. Then choose the tables and click OK as shown in the below picture.

CHOOSE TABLES FOR APPENDING

Step 3: Close & Apply

After you get the desired output as shown in the below picture, you can click on the Close & Apply button.

 DATA TABLE AFTER APPENDING QUERIES

APPENDED QUERIES

You can learn more :

Conclusion

In this article, We will learn about How to Append Query in Excel 2013 to 2019 Step-by-Step. If you want to learn more then check our high rated Power Query Course and become a power query expert in a week.

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…