Joining methods
In the previous recipe, you had the chance to see how to perform a merge where you reference a main table enriched with data coming from another table with geographical details. In fact, there are many ways to join data on matching values following a logic that belongs to traditional relational databases—for example, left/right/full outer joins, inner joins, and left/right anti-joins. These different methods allow users to match data by applying custom logic.
In this recipe, you will see how you can effectively leverage some of the most popular joining methods.
Getting ready
For this recipe, you need to download the following files:
FactInternetSalesCSV fileDimTerritory2CSV 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...
