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:
FactInternetSalesCSV fileFactResellerSalesCSV 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:
- Click on Get Data and select the Text/CSV connector.
- Browse to your local folder where you downloaded the two CSV files (
FactInternetSalesandFactResellerSales)and load them into the Power Query view:
Figure 5.20 – Queries pane
- Select the
FactInternetSalesquery, browse to the Add Column tab, and click on Custom Column:
Figure 5.21 – Custom...
