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 – https://forum.enterprisedna.co/t/comparing-two-table-and-appending-mismatches/19348

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

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