DAX Operators In Power BI

Introduction

 
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.
 
Operators
Meaning
=
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.
 
Operator
Meaning
&&
AND returns TRUE when both expressions return TRUE
||
OR returns TRUE
IN
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.
 
Operator
 Description

^

Exponentiation
-
Sign (as in -1)
*and /
Multiplication and Division
!
NOT (Unary Operator)
+ and -
Addition and Subtraction
&
Connnect two string
=, ==, <, > , <=, >=, <>
Comparision
 
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.
 

Summary

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