XLOOKUP v Power Query v Power Pivot
Wyn Hopkins
Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views
When combining tables in Excel there are several options.
In this video I show you XLOOKUP, Power Query Merge and a Power Pivot relationship. Power Query Merge comes with warning ??
Timestamps:
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
Wyn
Connect with me https://wyn.bio.link/
Our Team of consultants and trainers at Access Analytic https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
Senior Manager, Data & Advanced Analytics at Westpac Group
1 年I prefer power pivot when the process is repetitive. When we use measures the process is efficient. I use XLookup for small data sets and quick one off lookups.
Helping you be more productive with Excel, Word, Powerpoint and Office 365
1 年Was just shouting about the benefits of Xlookup. Then found out they were using Excel 2019 ??
Financial Accountant @ DAT
1 年I strongly favor Power Query & Xlookup i haven't needed to use Power Pivot
Senior Electrical Engineer | PMP | Project Coordinator | Excel Expert | Power BI | Power Query | Data Analysis
1 年Usually I use power query if I want to do transformation and if the data is large , Xlookup I use it also . Power pivot I rarely use it(mostly I use power bi)