Easily Compare Multiple Tables in Power Query

Learn how to easily compare 3 or more tables in Power Query and avoid having to do lots of complicated query merges.

0:33 Power Query Lists (Table Columns)
1:02 Checking Source Data
1:30 Load Table Into Power Query (Connection Only)
2:30 Using #shared to Create Function Reference Table
3:20 List.Intersect
4:28 Filtering Table Using Table.SelectRows and List.ContainsAny
6:33 List.Union
8:13 List.Difference

[SusithJayamanne]

Amazing! Super efficient way of saving minutes, hours and quite possibly days of manual and boring work. Thanks again Mynda and Phil!

[shoaibrehman]

What a level of expertise, this is a way of professional power query gr8 video.
I will learn and practice to implement in my daily work efficiently.
Please continue power query videos.
Thanks a lot

[GrainneDuggan_Excel]

Thanks Phil for such a clear demonstration of these LIST functions. I hope you do loads more MCode videos!

[dcpowered]

That was simply glorious!! I really enjoyed the explanation. Very calm and well spoken, both of you!! Please make more videos about tables in power query. Thank you!!

[IvanCortinas_ES]

Excellent tutorial Mynda. I love your dedication and how well you explain it. Thank you for telling us these List functions of M language.

[trentonjjrr]

It was very nice learning something new. I would have appended all three trainings. Transformed text to Proper. Grouped by Name for a count rows. Then add a merge query step to the Staff query to pull in the count. Add Conditional column that says if the [expanded column] equals null then 0 if not then [expanded column]. I think it’s a rather simple way to do it but just depends how you want your data presented.

[excelemployeeleavetracker]

Saving Time and Saving THEM COMING PLEASE!

[ricos]

Very good video. I'd have appended the three tables, using the training day (1, 2, 3) as an ID column then used power pivot for the rest, however this is a nice alternative. I'm always wary of producing my final result in power query (preferring to use it solely for transformation), but I'm not sure if my instincts are correct in that regard.

[naveen]

Explaining with real time use cases and hidden gem functions is awesome.

[mattschoular]

Thanks Mynda and Phil. I will be watching this one again when I'm at my desk...

[malikastar]

Thank you for this helpful tutorial, knowing the functions and how to use them make us understand the essence of PowerQuerry and be more confortable using them

[zahoorsarbandi]

Very informative and useful.. Specially the speaking style of the lecturer is simply wonderful.

[alpeshshah]

FANTASTIC INFORMATION, thank you for sharing this, I have so many uses for the list function now that I have seen the examples you have shown.

[bli]

This is fabulous! Set theory in action!

I’ve always dreaded merges given how slow they can get. Going to have to dig more into list functions. Thx so much for sharing!

[vijayarjunwadkar]

Thank you Mynda & Phil for this super useful video! I just have a need for a similar data problem I am handling and this video is just in time to help me! Really appreciate! 😊👍

[wayneedmondson]

Thanks Mynda and Phil. List functions are so powerful. Love to learn more ways to use them. Thanks for sharing :)) Thumbs up!!

[rsnsep]

Big Thx to Mynda and team, yet another informative video.

[the_slidemaster]

It's really that much easy.. Thanks for the tutorial..! Great work..! 👍👏

[syedaneesdurez]

Request to share more videos on such list examples and M Codes . Advise how can we learn M Code fast

[davidlinton]

Another great video! Thanks Mynda & Phil.