Operators

There are four groups of operators in DAX:

  • Arithmetic
  • Comparison
  • Concatenation
  • Logical

Table 1-7 shows the different types of operator available within the arithmetic group, along with an example illustrating typical use:

Operator

Meaning

Example

+

Addition

3 + 7 = 10

-

Subtraction or sign

10 - 7 = 3

*

Multiplication

10 * 7 = 70

/

Division

10 / 5 = 2

^

Exponentiation

3 ^ 4 = 81

Table 1-7: DAX arithmetic operators

When using arithmetic operators it is important to consider the order in which they need to be applied. If necessary, use parentheses to override the precedence of an operator. Table 1-8 shows the order of precedence for each of the different DAX arithmetic operators: ...

Get Hands-On Business Intelligence with DAX now with O’Reilly online learning.

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