May 14

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

1  comments

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

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

How to create a relative file path in Power Query

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV

Read More

Excel Tutorial Concat Function in Excel with TEXTJOIN – Excel.TV

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!

    >