DAX Operators
When several operators are combined in a single expression, the operations are ordered according to the following table, from the lowest to the highest precedence level number. If the operators have equal precedence value, they are ordered from left to right. For example:
- If an expression contains both a sum and a comparison, the sum is executed before the comparison.
- If an expression contains both a multiplication and division operator, they are evaluated in the order that they appear in the expression, from left to right.
| Priority Level | Operator | Description |
|---|---|---|
| 1 | () | Parentheses – grouping |
| 1 | F() | Scalar functions |
| 1 | IN | Inclusive OR list |
| 2 | ^ | Exponentiation |
| 3 | +, – | Sign – unary plus/minus (-1) |
| 4 | *, / | Multiplication, division |
| 5 | +, – | Addition, subtraction |
| 6 | & | Text concatenation |
| 7 | =, ==, <>, <, >, <=, >= | Comparison operators |
| 8 | NOT | Logical negation |
| 9 | && | Logical AND |
| 10 | || | Logical OR |
Last update: Apr 29, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen, MartÃn de la Herran
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies