Project Botticelli

Advanced Relationships Purchase this course

25 November 2017 · 106 views

Mastering DAX Workshop

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.

Purchase This Course or Full Access Subscription

Single Course

$350/once

Access this course for its lifetime*.
Purchase
Subscription Best Value

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses