DAX Operators In Power BI


DAX (data analysis expression) language uses a different kind of operator. These operators are symbols that are used to perform arithmetic calculations and logical manipulations.
Below is the list of different types of DAX operators like arithmetic, comparison, text concatenation and logical.

Arithmetic Operators

Arithmetic operations are used to perform mathematical operations such as addition(‘+’), subtraction(‘-‘), multiplication(‘*’), division(‘/’) or exponentiation(‘^’).
Comparison Operators
These operators are used to compare two values. The result of the comparison is a logical value, either TRUE or FALSE.
Equal to
Strict equal to
Less than
Greater than
Greater than or equal to
Less than or equal to
Not equal to
Concatenation Operator
This operator is used to join or concatenate two string together. Ampersand ‘&’ is used as concatenation operator.
Logical Operator
‘&&’ and ‘||’ are used as logical operators to combine expressions and produce a single result.
AND returns TRUE when both expressions return TRUE
OR returns TRUE
Creates a logical OR condition between each row being compared to a table

Operators and precedence order

In some cases, the order in which calculation is performed can affect the Return value; therefore, it is important to understand how the order is determined and how you can change the order to obtain the desired results.
Calculation Order
An expression assesses the administrators and qualities in a particular request. All expressions consistently start with an equivalent sign (=). The equivalent sign shows that the succeeding characters establish an expression.
Following the equivalent sign are the components to be determined (the operands), which are isolated by count administrators. Articulations are constantly perused from left to right, however the request wherein the components are gathered can be controlled somewhat by utilizing brackets.
Operator Precedence
Below is the list of order of operators according to the precedence value. If they have equal precedence then they are ordered from left to right. Ordering is a must if a formula has many operators.


Sign (as in -1)
*and /
Multiplication and Division
NOT (Unary Operator)
+ and -
Addition and Subtraction
Connnect two string
=, ==, <, > , <=, >=, <>
Using parentheses to control calculation order
If you want to change the order of evaluation, you have to enclose the part of calculation in parenthesis that you want to calculate first. For example: - If you calculate 7+4*3 then you will get 19. But in contrast, if you want to add 7 and 4 together then multiple by 3, you have to use parenthesis like (7+4)*3 and you will get 33.


These are some operators that are used to perform calculations and generate DAX formula. Hope you understand. Thanks for reading. Have a nice day.