Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel)

In this video, we show you how to merge two queries in Power Query. For the avid Excel users, this is a similar [but more powerful] process to a VLOOKUP.

Using employee details, we add the employees' pay rate by merging a query containing employee IDs and pay rates. By going through the steps of merging the two queries, we discuss the differences between "Merge Queries" and "Merge Queries as New". We also explore the different types of joins you can perform to merge the two queries, which include Left Outer, Right Outer, Full Outer, Inner, Left Anti, and Right Anti.

In the final step, we demonstrate how to expand the desired columns from the query that was merged in. While this is a relatively simple task to perform in Power Query, we provide the little details so that you can get it right.

Hope you enjoy this video and we'll see you in the next one!

For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.

About Go Analytics Inc.

We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.

Need help getting started with Power BI? Let's connect!

***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.

[raffaelecamillo]

This is best video about this topic in all my research in YouTube. Easy to understand and well explained! Thanks a lot!👍

[simonmengue]

Best video i have found about this topic. easy and simple explanation. Thank You Bro

[rstand]

Thank you for clarifying the Join Kind types.

[palmerimsoaresdesa]

It's been simple amazing! Thank you very very very much for this primorous explanation

[andreashermle]

Another great video from your side.Thank you