How to Create Joins in DAX with/without Relationships — DAX in Power BI — Chapter 5

Exploring how to combine data from different tables with or without a relationship in DAX.

Image from Unsplash

For most cases, we can consider defined standard relationships in DAX calculations as per the data model. But it is not applicable every time. For more flexibility, there are some DAX functions are available that support joining tables.

Standard Relationship in DAX

When a data model has more than one table, it is possible to have a relationship between them that will be used by DAX during calculations.

There are some limitations where this DAX relationship process does not work.

Only One to One and One to Many relationships

Image by Author

The product table has a unique row and for every product, there are multiple rows in the sales table.

For the one to one relationship, the column involved in each table must have unique values.

Only a single column from each table…