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 2. Introducing DAX

After the quick introduction of the previous chapter, it is now time to start talking about the DAX language. In this chapter, you learn the syntax of the language, the difference between a calculated column and a measure (also called Calculated Field, in Excel terminology), and the most commonly used functions in DAX.

As this is an introductory chapter, many functions are not covered in depth. In later sections of the book we go deeper and explain them in more detail. For now, it is enough to introduce the functions and start looking at the DAX language in general.

Understanding DAX calculations

To express complex formulas, you need to learn the basics of DAX, which includes the syntax, the different data types that ...

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