You can watch all Power Query Join Types in action and see them explained in this video. But we are going to take things even further. We will create a "LOOKUP Dashboard," which will be a single table, but it will also be a concept you can develop onwards. I hope you learn a lot from this video.
You can download the file I used in this video here: excelolympics.com/wp-content/uploads/2022/02/Joins-in-Power-Query.xlsx
Links to blog posts and videos that are relevant:
Ultimate Vlookup alternative? (Part 1) (Excel Unplugged) - bit.ly/3I9EgLt
Ultimate Vlookup Alternative? (Part 2) (Excel Unplugged) - bit.ly/3A1gD57
Power Query vs. Excel video: bit.ly/3uMMiGI
Power Query vs. Xlookup in Excel: bit.ly/33l82OO
Excel Olympics YouTube Channel: youtube.com/c/ExcelOlympics
Chapters:
0:00 Intro
0:08 Introduction to the video
1:02 Tables we are using explained
2:13 Left Outer Join Kind
4:26 Right Outer Join Kind
7:03 Full Outer Join
9:07 Inner Join
10:31 Left Anti Join
11:34 Right Anti Join
12:29 Starting the Lookup Dashboard
21:20 Building the Dashboard
23:12 One-Click Refresh
26:23 Conclusion
26:42 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS
Laptop: Dell XPS 15 - amzn.to/3w8CyoK
Lights: Elgato Key Light - amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - amzn.to/3amDRXP
Laptop: Dell XPS 15 - amzn.to/3effMmT
Lights: Elgato Key Light - amzn.to/3vcs6v9
Green Screen (visible in bloopers): amzn.to/3ajUm6Y
Recorded With: Camtasia - techsmith.com/video-editor.html
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: bit.ly/EOYTsub
Subscribe to the Excel Olympics Newsletter: bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
- Join Types in Power Query ( Download)
- Multiple JOINS Types for Beginners | Power Query and Power BI (2021) Tutorial ( Download)
- 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 ( Download)
- Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins Explained ( Download)
- Power Query Join Types ( Download)
- 39. Join Tables / Merge Queries | Joins in Power Query Editor ( Download)
- Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel) ( Download)
- An Introduction on 6 types of Joins in Power Query / POWER BI ( Download)
- Databse Join Query | Inner Join | Full Join | Left Join | Right Join #shorts #coding ( Download)
- Aggregating Joins in Power Query: the mysteries ( Download)
- Conditional JOIN using Power Query | A different way of merging in Power BI ( Download)
- How to Join Tables in Excel | Merge or Append Data From Different Sheets Using Power Query ( Download)
- New: Semi-Joins in Power Query + a Brief Overview of Power Query's Outer and Inner Joins ( Download)
- How To Easily Merge Tables With Power Query: Vlookup Alternative ( Download)
- MERGING tables and how to use the different JOIN KINDS // Beginners Guide to Power BI in 2021 ( Download)
