Merge Operations in Power BI / Power Query

14-04-2019  0 Comment(s)
  • then we find the file that we downloaded (with the name of Sample Data.xlsx). We then select the option to “Select multiple items” and we select both the ExportedData and ExclusionTable tables:
  • ExportedData – similar to the previous post, you can imagine that this table comes out hot out of the Global system that the company uses and it comes with some data that I truly don’t need
  • ExclusionTable – with the combination of values that we want to filter out of the ExportedData table
  • The first thing that we need to do is load both of those tables to Power Query / Power BI. To do that, we simply go to Data > Get & Transform Data > Get Data > From File > From Workbook:
  • and then we click on ‘Transform Data’ or ‘Edit’ depending on what version of Power Query / Power BI you might have.

    That should land both of your tables inside the Power Query editor as shown below:

Comment Here


No Comments to Show