From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Merge and append queries

Merge and append queries - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Start my 1-month free trial Buy for my team

Merge and append queries

“

- [Instructor] In this sub-lesson, we are going to look at merging and appending queries. Generally, use an append whenever you want to combine rows of two similar tables into a single table. As a general rule with append, you generally get more rows, but not necessarily more columns, although it is possible, and we'll show you that with some examples later. Merge is used when we want to combine columns with two related tables into one table. It is like a JOIN in SQL or a VLOOKUP over in Excel. So what this looks like with an animation here, let's take these two queries, Query 1 and Query 2. You'll see they both have three columns each, A, B, and C. Query 1 has three rows, Query 2 has four rows. We'll go ahead and run append on this. We're simply going to end up with seven rows in query number one. In this case here, we have Query 1 and query number two. And if we append these, we can see that Query 1 has columns A, B, and C, and Query 2 has A, B, and X. So each one of the queries has…

Contents