The 6 Joins in Power Query: Explained

You’ve seen the Joins in other videos, but here is a fun overview of all 6 joins in Excel’s Get & Transform (Power Query)

2:39 Creating Queries
3:47 Full Outer Join
6:00 Left Outer Join
7:18 Right Outer Join
8:45 Inner Join
9:51 Right Anti Join
11:24 Left Anti Join
13:06 Something Crazy


My book: Guerrilla Data Analysis 2nd Edition
My old blog: