In this final section, you will learn how to handle complex relationships between tables by leveraging the DAX language. The goal is not to just give you pre-built patterns that you can use in your model. Instead, we want to show you unusual ways of using DAX to build complex models, to widen your idea of relationships, and to let you experience what you can achieve with DAX formulas.

Tabular models can only handle simple and bidirectional relationships between tables and this might look somewhat limited. However, taking advantage of the DAX language, you can create very advanced models with all kinds of relationships, such as inactive ones, multi-column ones, and also virtual ones. As usual, DAX is the key to solving complex scenarios.

We will highlight several techniques for modelling complex relationships, including patterns such as static segmentation, dynamic segmentation, working at differenct granularities, many-to-many relationships, and new and returning customers.

Now you are ready to practice the final and rather complex Lab 9.

Log in or purchase access below to the premium version of this content.