Compare tables using Power Query Editor in Power BI or Excel

⚠️ SPEECH ERROR at • Compare tables using P... "the result of the tables A & B merge is 4 rows (not columns) that are unique to the table A and that are not present in the table B"⚠️
In this video I am showing how to compare tables using Power Query Editor in Power BI or Excel.
By using merge functionality you can perform a quick comparison of two tables.
In this channel I post Power BI tutorials on how to improve your Power BI dashboard. I share tips for Power BI beginners. Learn more about Power BI ( DAX, Power Query, dataflows), Power Automate and Microsoft Fabric.
#except
#union
#powerbi
#microsoftpowerbi
#powerbidashboard
#powerbitips
#powerquery
#microsoftpowerquery
#microsoftfabric
#msfabric
#powerbidax
#tooltips
#customtooltips
#powerbitutorial
#powerbitutorials
#powerbitutorialforbeginners
#powerbitraining
#drillthrough
#powerbidrillthrough
#dashboard
#dashboarddesign
#powerbioptimization
#slicers
#dateslicer
#powerbidateslicer
#datetable
#powerbidatetable
#datavisualization
#daxqueryview

[@lenazaitceva]

I appreciate your short and clear video tutorials. Hope you keep sharing more.

[@SugarSyntax]

Thank you 🙏

[@rainrzufall]

Try
=Table.RemoveMatchingRows( #"Table A", Table.ToRecords( #"Table B" ) )

[@EugenioLikedit]

Great tip! Might be too advanced for the beginner Power Query users who are not comfortable to write M script 🙂

[@SugarSyntax]

Thanks for sharing! This is an excellent advanced method of comparing tables.