XLOOKUP v Power Query v Power Pivot in Excel

When combining tables in Excel there are several options.

Here I show you XLOOKUP, Power Query Merge and a Power Pivot relationship.

00:00 Intro
00:43 The scenario
00:51 XLOOKUP
02:36 Power Query Merge
05:47 The Power Query Merge Warning
07:27 Using a Data Model Relationship (Power Pivot)
10:12 Wrap Up


Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/