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.

Merge the product and product rollup queries

Merge the product and product rollup 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

Merge the product and product rollup queries

“

- [Instructor] Okay, so what we are going to do next, given that we just imported the product rollup query and we previously created the product query, what we're going to do now is merge these two queries together. And the reason we want to do that is we want to take the product category from the product query, which we just brought in. And we want this column's values to show up over in this query as an additional column. So, we would like to do that for a couple of reasons. Number one, is that when it comes to end user self-service, we want to make sure that we have the fewest number of tables possible. Generally, that just makes models less intimidating. The fewer the tables, the fewer columns, the more approachable your model is. That's one reason. The second reason is we're going to do this for performance benefits. We're going to essentially later on prevent the product rollup table from showing up in the data model, and we're only going to bring the one column that we care…

Contents