Compare tables using Power Query Editor in Power BI or Excel. Advanced method
In my previous video I have already shown how to compare 2 tables in Power Query in Excel & Power BI using Merge functionality. This is a simple way for someone who is just starting to use Power Query:
• Compare tables using Power Query Editor in...
However, this method is might time consuming as you need to map all the joining keys and if you have many columns this will take time to map all of them to a table you want to compare.
For a more advanced users who is comfortable to write Power Query scripts I suggest to use function Table.RemoveMatchingRows.
By the way, this tip was suggested by @rainarzufall in the comments section under my previous video. Thanks for this tip. However, I think it requires explanation on how to use it.
Hence, I have made this video.
This method involves 2 functions:
Table.RemoveMatchingRows & Table.ToRecords
https://learn.microsoft.com/en-us/pow...
https://learn.microsoft.com/en-us/pow...
Need my Help? Email me [email protected]
My LinkedIn: / evgenycheredov
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