Enter your email to track your progress and stay up-to-date on new Power BI learning content.
By clicking Track progress, you are giving your consent to Microsoft to provide you updates about Power BI learning resources via email. You can unsubscribe at any time.
As you progress through Guided Learning, a green checkmark will appear next to your completed topics.
With an introduction complete, get ready to dive deep!
Power BI lets you create relationships among multiple tables, including tables that come from completely different data sources. You can see those relationships for any data model in the Relationships view of Power BI Desktop.
DAX has relational functions that enable you to interact with tables that have established relationships.
You can return the value of a column, or you can return all rows in a relationship using DAX functions.
For example, the TABLE function follows relationships and returns the value of a column, while RELATEDTABLE follows relationships, and returns an entire table that is filtered to include only related rows.
The RELATED function works on many-to-one relationships, while RELATEDTABLE is for one-to-many relationships.
You can use relational functions to build expressions that include values across multiple tables. DAX will return a result with these functions, regardless of the length of the chain of the relationship.
Video content courtesy of Alberto Ferrari, SQLBI