Excel DAX - Arithmetic Operators



You can use DAX arithmetic operators to perform basic mathematical operations such as addition, subtraction, multiplication, division, and exponentiation. These DAX operators cast numeric data type to the values with which they are used, if they are not already numeric values. They produce numeric results after the calculations.

Arithmetic Operator Mathematical Operation Example Result
+ Addition 5+4 9
- Subtraction 5-4 1
Sign -4 -4
* Multiplication 5*3 15
/ Division 16/4 4
^ Exponentiation 4^2 16

The above DAX arithmetic operators are known as binary operators, meaning they combine two values on either side, as you can observe in the examples above.

The DAX arithmetic operators + and – can also be used as unary operators, meaning that the DAX operator can be used only with one value. For example, +5, -4. These unary operators can be used with any data type. However, there is a subtle difference between the two −

  • The + operator when used with a value or a result, it does not convert the data type of the value. It is just ignored. For example, + Seasons is same as Seasons.

  • On the other hand, the – operator when used with a value or a result, converts the data type of the value to a negative numeric value. For example, – Seasons = -4 if the value of Seasons is 4.

excel_dax_operators.htm
Advertisements