May 14

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

Using Power Query to Connect Tables for Reporting | Excel.TV, Episode 55

An Excel Joke to Start Off...

Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them. 

And that's what we're doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.  

This week, I've simplified it all using a left outer join. This is a really cool feature that lets you treat Excel like a database. You can a very similar use of joins in Szilvia's video, by clicking here.

Watch the entire video to see how I join two different tables using name as the primary key! 

Get the Download File

Get the file by clicking this link.

What do you think? How do you connect tables?

Let us know in the comments.

Loved this? Spread the word

About the Author

Jordan Goldmeier

Related posts

All Excel LOOKUPs Explained

Read More

How to: Power Query File From Folder

Read More

2020 – I can’t wait!

Read More

Oz’s Excel Tip: Keep a Workbook for Random Data in Excel

Read More
  • I use this function pretty much daily. I’ve always heard that it is better to use power pivot though. The problem I have though with power pivot is that if there are more than one of the same value in each table, it doesn’t work. So I just use the merge query capability in get and transform. I never have any problems with it.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Subscribe to our newsletter now!