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: [ Ссылка ]

Links to blog posts and videos that are relevant:
Ultimate Vlookup alternative? (Part 1) (Excel Unplugged) - [ Ссылка ]
Ultimate Vlookup Alternative? (Part 2) (Excel Unplugged) - [ Ссылка ]

Power Query vs. Excel video: [ Ссылка ]
Power Query vs. Xlookup in Excel: [ Ссылка ]
Excel Olympics YouTube Channel: [ Ссылка ]


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 - [ Ссылка ]
Microphone: AKG C3000 (Analog Mic) - [ Ссылка ]
Audio converter: Zoom UAC-2 - [ Ссылка ]
Laptop: Dell XPS 15 - [ Ссылка ]
Lights: Elgato Key Light - [ Ссылка ]

EU Links
Camera: Canon EOS R6 - [ Ссылка ]
Microphone: AKG C3000 (Analog Mic) - [ Ссылка ]
Audio converter: Zoom UAC-2 - [ Ссылка ]
Laptop: Dell XPS 15 - [ Ссылка ]
Lights: Elgato Key Light - [ Ссылка ]
Green Screen (visible in bloopers): [ Ссылка ]

Recorded With: Camtasia - [ Ссылка ]

Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: [ Ссылка ]

Subscribe to the Excel Olympics Newsletter: [ Ссылка ]

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

свернуть