Chapter 13

DAX Language Reference

In This Chapter

•   DAX Operators

•   DAX Functions

Entire books could be written, and have been written, about the DAX language. We worked with DAX expressions in Chapter 12. In this chapter, we take a closer look at the DAX language.

The power of the DAX language comes from functions. Almost all DAX expressions will include at least one DAX function. Therefore, the majority of this chapter will be about DAX functions. Before we get to that, let’s make sure you understand the very basics—DAX operators.

DAX Operators

DAX operators can be divided into four categories: comparison operators, arithmetic operators, text operator, and logic operators.

Comparison Operators

Comparison operators are used to make a ...

Get Data Analysis with Microsoft Power BI now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.