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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.