O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Advanced relationships

This is the last chapter on DAX. The remaining part of the book covers internals of the engine and optimization techniques to make your code run faster. This means that after reading this chapter we will have shared with you all of our DAX knowledge.

In this chapter, you will learn how to handle complex relationships between tables by leveraging the DAX language. Tabular models, in fact, can handle simple or bidirectional relationships between tables and this might look somewhat limited. However, taking advantage of the DAX language, you can create very advanced models with basically any kind of relationship, including virtual ones. As usual, DAX is the key to solve complex scenarios.

We will highlight several ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required