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 6. DAX examples

At this point of the book, you have a solid background in the DAX theory and it is time to start using DAX to solve some interesting scenarios. In this chapter we show some examples of DAX usage.

Be aware that the goal of the chapter is not that of providing ready-to-use patterns. For each scenario, we will build the formulas and describe the calculations with the intent of showing the process of solving a problem using DAX.

The goal of the chapter is to help you begin “thinking in DAX.” In our experience, DAX becomes simple to use as soon as you acquire this unique skill. The way you describe an algorithm in DAX is very different from SQL, Microsoft Excel, MDX, or any other programming language. At the beginning, the ...

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