From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

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

Append sale queries

Append sale queries - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Append sale queries

“

- [Instructor] Okay, so what we're going to do now in this next lesson is I first want to go and load all the data from my sources through the Power Query editor using all the transformation reels I just set up. So I'm just going to click Close and Apply, and let that data move its way over in the data model. And we can see here I've got my six tables, customer, other country sales product, product, rollup, sales territory, and United States sales. The objective of this exercise is to combine the other country's sales and United States sales into a single table. So that if we ever want to do global sales analysis, we can do it all from one place. So let's go ahead and do that. So I'm going to go back over to the Power Query editor. I am going to find my other country sales table or query right here. And what I'm going to do at the home tab is on the far right-hand side, I'll see this combined menu, click on this and I'm going to say append. And from the append options, I'm going to…

Contents