Learn how to easily compare 3 or more tables in Power Query and avoid having to do lots of complicated query merges.
0:33 Power Query Lists (Table Columns)
1:02 Checking Source Data
1:30 Load Table Into Power Query (Connection Only)
2:30 Using #shared to Create Function Reference Table
3:20 List.Intersect
4:28 Filtering Table Using Table.SelectRows and List.ContainsAny
6:33 List.Union
8:13 List.Difference
Download the Excel file that includes the data and queries in this video: myonlinetraininghub.com/easily-compare-multiple-tables-in-power-query
View my comprehensive courses: myonlinetraininghub.com/
Connect with me on LinkedIn: linkedin.com/in/myndatreacy/
- Easily Compare Multiple Tables in Power Query ( Download)
- Add a conditional column Power Query Editor Power BI ( Download)
- Replace Values Based on Condition (in a Single Step) in Power Query ( Download)
- Power BI quick trick…How To Conditionally Replace Values using if..then..else within replace! ( Download)
- Create Buckets or Groups with Power Query in Power BI ( Download)
- 13) PowerBIWorld: How to give condition in columns into Power query, Conditional Columns ( Download)
- How to COMBINE DATA with MERGE and APPEND in Power BI ( Download)
- 16. Multiply Column By A Standard Value | Multiplication Transformation in Power Query Editor ( Download)
- Power BI Tutorial for Beginners 19 - Power Query to Concatenate Columns ( Download)
- Manage column - Choose Columns & Remove Columns in Power BI ( Download)
- 11.2 How to Split & Trim Text in Power BI (Power Query) | Power BI Tutorial for Beginner ( Download)
- Use Power Query conditional column to filter by multiple columns and criteria ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
- Power BI Tutorial for Beginners | Appending tables with different columns | Power Query ( Download)
