Power Query tutorial for beginners on how to merge two queries within power query. Merging query feature is helpful when you have two or more datasets that needs to be combines using one common column to produce a single dataset for reporting.

Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com

In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standard and professional looking business dashboards.

Power BI Tutorials Google Sheet- [ Ссылка ]

Dataset - [ Ссылка ]

#powerbi #datacleaning #datatransformation #powerquery

What is merge query feature of power query?

The Merge Query feature in Power Query is a transformation that allows you to combine two or more tables based on matching values in one or more columns. This can be useful for combining data from different sources, such as a customer database and a sales database.

To merge queries in Power Query, you can follow these steps:

Open the Power Query Editor.
Select the tables that you want to merge.
Click on the Home tab.
In the Combine group, click on the Merge queries button.
In the Merge dialog box, select the columns that you want to use to merge the tables.
Select the type of join that you want to use.
Click on the OK button.
The merged table will be created and added to the Power Query Editor.

Here are some of the different types of joins that you can use in the Merge dialog box:

Inner join: This is the default join type. It returns all rows from the left table that have matching rows in the right table.
Left outer join: This returns all rows from the left table, even if there are no matching rows in the right table. The unmatched rows in the left table will have null values in the columns from the right table.
Right outer join: This returns all rows from the right table, even if there are no matching rows in the left table. The unmatched rows in the right table will have null values in the columns from the left table.
Full outer join: This returns all rows from both tables, even if there are no matching rows in the other table. The unmatched rows in either table will have null values in the columns from the other table.
I hope this helps! Let me know if you have any other questions.

свернуть