Appending queries 165

Appending queries

Within a single table, you often need to have data coming from different files/tables. You need to append data and have a unique view that will allow you to run more complex analyses. In this recipe, you will see how you can append data in Power Query with just a few clicks.

Getting ready

For this recipe, you need to download the following files:

•FactInternetSales CSV file

•FactResellerSales CSV file

In this example, we will refer to the C:\Data folder.

How to do it…

Once you open your Power BI Desktop application, you are ready to perform the following steps:

1.Click on Get Data and select the Text/CSV connector.

2.Browse to your local folder where you downloaded the two CSV files (FactInternetSales and FactResellerSales) and load them into the Power Query view:

Figure 5.20 – Queries pane

166Combining Queries for Efficiency

3.Select the FactInternetSales query, browse to the Add Column tab, and click on Custom Column:

Figure 5.21 – Custom Column button

4.Create a new column called Channel, add as a formula the value Internet, and click on OK:

Figure 5.22 – Custom Column window

Repeat this step for the FactResellerSales query, with the only difference being on the value to define in the added column. Instead of Internet, enter Reseller:

Appending queries 167

Figure 5.23 – Custom Column window: Reseller

You should end up with an added column for each query, as shown in the following screenshot:

Figure 5.24 – New added columns