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.<\/p>\n
Melissa<\/p>\n
***** Video Details *****
\n00:00 Introduction
\n00:41 Table.RemoveMatchingRows
\n01:36 Table1 as a list of rows
\n02:05 Columns that don\u2019t match
\n02:15 Table2 with additional column
\n02:39 Optional equation criteria argument<\/p>\n
***** Related Links ***** ***** Learning Power BI? ***** #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial#PowerQuery #PowerQueryTutorial<\/p>\n","protected":false},"excerpt":{"rendered":" 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<\/p>\n","protected":false},"author":3,"featured_media":2791,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/09\/sWEtboeHJl8.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-IZ","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2789"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2789"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2789\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2791"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nComparing Two Table And Appending Mismatches Forum Post – https:\/\/forum.enterprisedna.co\/t\/comparing-two-table-and-appending-mismatches\/19348<\/a><\/p>\n
\nFREE COURSE – Ultimate Beginners Guide To Power BI – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-power-bi<\/a>
\nFREE COURSE – Ultimate Beginners Guide To DAX – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-dax<\/a>
\nFREE – Power BI Resources – http:\/\/enterprisedna.co\/power-bi-resources<\/a>
\nFREE – 60 Page DAX Reference Guide Download – https:\/\/enterprisedna.co\/dax-formula-reference-guide-download\/<\/a>
\nEnterprise DNA Membership – https:\/\/enterprisedna.co\/membership<\/a>
\nEnterprise DNA Online – http:\/\/portal.enterprisedna.co\/<\/a>
\nEnterprise DNA Events – https:\/\/enterprisedna.co\/enterprise-dna-events-page\/<\/a><\/p>\n