From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

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

Active versus inactive relationships

Active versus inactive relationships - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Active versus inactive relationships

“

- [Instructor] Let's take a minute and talk about something called active versus inactive relationships. Consider this data model here. This is the same model that we're working with. You'll note that on the right side of the model, we actually have two relationships drawn between the Calender_Lookup table and this FoodMart_Transactions table, and the reason there are two lines is because there are two date fields in the Transactions table and only one date field in Calendar. So what we've done in this case is we've drawn a relationship between each of the date fields in the Transaction table. But the issue is that both can't be active at the same time. So if you were to right-click or double-click each of those two lines, you would see the following Edit Relationship windows, and if you look really closely at the bottom left corners, there's a box that says Active, and only one of the two is checked. Now the one…

Contents