Power Query (Excel) + M Code | Compare multiple tables - No Code to M Code (MATCH)

This video will show you to compare multiple tables in three methods.
Method 1 - Merge Queries (No Code)
Method 2 - Table.RemoveMatchingRows
Method 3 - List.Union | List.Intersect | List.Difference

Topic:
0:00 - Intro
0:14 - Case Explain
0:42 - Method 1: Merge Queries
2:05 - Method 1: Table.RemoveMatchingRows
3:23 - Method 3: List.Union | List.Intersect | List.Difference

Workbook:
N/A

[jeromeastier]

Excellent tutorial. I really appreciate the progression. In the complexity of the example and the solutions.

[mirrrvelll]

Well done!!! I asked you maybe 2 weeks ago about this topic! I knew 2 of 3 methods but last one is Excellent, exactly for my purpose!!! Your video sounds and looks amazing...but that "group of aunty" :D :D :D haha!

[Sumanth]

Group of Aunty 😂😂 loved this topic... many will find it useful for reconciliation.. brilliant 👏🙂

[jhaanand]

Ur a genius please prepare a video on consolidating data when column header changes.

[StefanoVerugi]

useful stuff, good animation and speed, very educative
thanks a lot for posting
ps when are you going to try your voice over? 😉

[qasimjan]

By the way what kind of tool you are using like for your animation, highlighting, pointing, circling you know the kind of effect you are bringing in your videos. I want to use it for writing like giving it a book effect. Maybe you got the point.

[qasimjan]

Your content on power query is really top-notch.