From the course: Project Online Reporting with Power BI

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Working with inner joins

Working with inner joins

From the course: Project Online Reporting with Power BI

Start my 1-month free trial

Working with inner joins

“

- [Instructor] In this session, we'll add in additional tables into our dataset. To do that we'll go to recent sources and select the recent source. Here we're going to add in our Projects table, Resources table, Resource Time Phase dataset, and lastly a Time Set that's going to give us just time by months, days, weeks, and so forth that we can use across multiple tables. So we'll press load. Now that our tables have loaded, we can start to review the joins between them. I'm going to go over to the Model area and in here I can start to see what's connected. Now you may want to edit some of these and in our case we definitely need to create a join between our Time Set table and our Time Phase tables. So I'm going to collapse the fields and the properties and I'll start to move these over so that I can get those into my view. So I'll bring up the Assignments area and bring over the Resource Center table. The others are…

Contents