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 - Power BI Tutorial
From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Recap of functions2m 24s
-
(Locked)
Row and filter contexts6m 58s
-
(Locked)
Using the CALCULATE function2m 44s
-
(Locked)
Creating dates with CALENDAR and CALENDARAUTO3m 48s
-
(Locked)
Accessing related data with the RELATED function2m 22s
-
(Locked)
Overriding default relationships with functions2m 44s
-
(Locked)
Time-intelligence functions4m 37s
-
(Locked)
Statistical functions3m 48s
-
(Locked)
-
-