Power BITutorials

Top 3 Steps to Append Queries Using Power Query

1 Mins read

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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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.

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

Leave a Reply

Your email address will not be published.