Comparing tables is a very common task in Excel and can get tedious if you do it manually all throughout. In this tutorial, I'll show how you can easily compare two tables in Power Query to isolate the items that do not appear on both tables and report the differences.

Melissa

***** Video Details *****
00:00 Introduction
00:41 Table.RemoveMatchingRows
01:36 Table1 as a list of rows
02:05 Columns that don’t match
02:15 Table2 with additional column
02:39 Optional equation criteria argument

***** Related Links *****
Comparing Two Table And Appending Mismatches Forum Post - forum.enterprisedna.co/t/comparing-two-table-and-appending-mismatches/19348

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial#PowerQuery #PowerQueryTutorial

• Easily Compare Two Tables in Power Query ( Download)
• Easily Compare Multiple Tables in Power Query ( Download)
• Excel PowerQuery: Match multiple columns between two tables ( Download)
• Compare Two Columns with Microsoft Excel Power Query | Excel Formula Hacks ( Download)
• Performing a full Anti Join in Power Query - Compare Two Tables ( Download)
• Best Way to Find the Difference Between 2 Large Lists | Excel Power Query ( Download)
• Compare different files QUICKLY using Power Query in Power BI // Beginners Guide to Power BI in 2021 ( Download)
• Compare Tables for Unmatched Records in Excel with Power Query ( Download)
• Master Excel 2024: Advanced Data Analysis with Power Query, Unique & Filter Functions ( Download)
• How To Easily Merge Tables With Power Query: Vlookup Alternative ( Download)
• Power Query (Excel) + M Code | Compare multiple tables - No Code to M Code (MATCH) ( Download)
• Comparing two tables and get unmatched data in power bi DAX | Power bi tutorial | power query ( Download)
• Compare Two Lists in Excel using Power Query ( Download)
• Excel How To Compare Two Tables in a Second ( Download)
• 3 Ways to SIMPLY Compare Matching Values Across Two Files Using Power Query | #powerbi ( Download)