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: ...
