From the course: Power BI Weekly

Unlock this course with a free trial

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

USERELATIONSHIP DAX filter function

USERELATIONSHIP DAX filter function - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

USERELATIONSHIP DAX filter function

“

- [Instructor] Power BI gives us a lot of flexibility and options for working with dates and time intelligence. Let's say we have a calendar table containing dates for our model. We can also add columns to this dates table for the end of the week and the end of the month, for example, to increase the model dimensions that we're analyzing our dates over. Date tables serve important roles in modeling Power BI, like representing dimension tables or keys that connect the fact table storing the data and the model together. If we want to connect two date fields in a fact table to the same date field in the dates table, though, this causes problems because we can only have one active connection between two tables at any one given point in time. The work-around for this problem is by using the use relationship function as a filter in a dax measure to make the inactive relationship, represented by the dotted line here, an active one.…

Contents