From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

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

Overriding default relationships with functions

Overriding default relationships with functions

- [Instructor] There are times when we'll need to have multiple relationships between two tables. When we have two relationships created between tables only one can be active at a time. Consider the scenario where we have a date table and a sales table. The sales table has two date fields. That's order date and delivery date, both fields. So which we may want to filter reports. So this means that we need to have a relationship between both fields in the sales table and the date field in the date table. And since we can only have one active relationship at a time, then whichever is the secondary relationship it has to stay in an inactive state. So how then can we create reports based on the secondary relationship, which in our case is the delivery date field? The use relationship function index allows us to activate our relationship temporarily for the purposes of creating calculations using that inactive relationship. So…

Contents