Join Types in Power Query
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: https://excelolympics.com/wp-content/...
Links to blog posts and videos that are relevant:
Ultimate Vlookup alternative? (Part 1) (Excel Unplugged) - https://bit.ly/3I9EgLt
Ultimate Vlookup Alternative? (Part 2) (Excel Unplugged) - https://bit.ly/3A1gD57
Power Query vs. Excel video: https://bit.ly/3uMMiGI
Power Query vs. Xlookup in Excel: https://bit.ly/33l82OO
Excel Olympics YouTube Channel: / 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 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe to the Excel Olympics Newsletter: https://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