Uploaded October 2024 | Updated September 2026, 2 weeks ago

---

This is an in-depth explanation of multiple Power Query techniques and the performance of each approach.

🤯 The final query uses Table.Transform, List.Transform and List.Accumulate

Here's the file
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Eov31vD2lehLqJJOhReuKaQBmiIYAj3AUACttpJtoMhRAw?e=pYmsQ3


00:00 Intro, explanation and summary
04:17 Getting the data set up
--------------------
05:30 Single Column Examples
05:32 Exact Match (Merge) FAST
07:17 Exact Match (Formula) SLOW
09:32 Partial Match with Ignore case (Custom Column) SLOW
------------------
13:40 Multiple column Examples
14:55 Exact Match (Unpivot) SLOW
15:42 Exact Match (Single Formula) VERY SLOW
17:20 Exact Match with ignore case (Single Formula) FAST
20:23 Partial Match (Long Formula) FAST



The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

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


Connect with me
wyn.bio.link