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.

Build relationship between order date and sales

Build relationship between order date and sales - 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

Build relationship between order date and sales

“

- [Instructor] Okay, so in this sub lesson, all we're going to do is build the relationship between the order date table and the sales table. So to do that we're going to go back to the data model, and we can see here that when I look up my model here, I'm just going to close my properties card. Here is the table called order date that we built up. So I'm going to put this over here and what we're going to do is simply connect the order date here here to the order date over in the sales table. I click the mouse button down and I can drop it right there. And we'll see that it goes ahead and builds the one to many relationship with the filters flowing from the order date table over to the sales table. So there we go, now we are essentially ready to go ahead and use our date table in our DAX expressions. So just to summarize, what we've done so far in this particular lesson is we first went and created the date table. So we went and built this date table out first. So we did that using…

Contents