DAX (Data Analysis Expressions) Operators and Data Type in Power BI
Here's the list of DAX operators in a table format: Arithmetic Operators Operator Description Example + Addition = + - Subtraction = - * Multiplication = *…
Author
SQLDataDev Editorial Team
Mar 19, 2026 2 min read
Here's the list of DAX operators in a table format:
Arithmetic Operators
Operator
Description
Example
+
Addition
= +
-
Subtraction
= -
*
Multiplication
= *
/
Division
= /
^
Exponentiation
= ^ 3
Comparison Operators
Operator
Description
Example
=
Equal to
= = "North"
<>
Not equal to
= <> "South"
>
Greater than
= > 500
<
Less than
= < 500
>=
Greater than or equal to
= >= 500
<=
Less than or equal to
= <= 500
Text Operators
Operator
Description
Example
&
Concatenation
= & " " &
Logical Operators
Operator
Description
Example
&&
AND
= > 500 && = "North"
||
OR
= > 500 || = "North"
NOT
NOT
= NOT( > 500)
Other Operators
Operator
Description
Example
IN
In a specified list of values
= IN {"North", "South"}
BLANK
Represents a blank value(NULL value)
= IF(ISBLANK(), 0, )
TRUE
Logical constant for true
= IF( > 500, TRUE(), FALSE())
FALSE
Logical constant for false
= IF( <= 500, FALSE(), TRUE())
Operator Precedence
Order
Operators
1
Exponentiation (^)
2
Multiplication and division (*, /)
3
Addition and subtraction (+, -)
4
Comparison (=, <>, >, <, >=, <=)
5
NOT (NOT)
6
AND (&&)
7
OR (`||')
Data types
In Power BI, data types are important for accurately representing and interpreting your data. Power BI supports various data types, including:
Text: Used for alphanumeric characters, such as names, descriptions, or any other textual data.
Whole Number (Integer): Used for integer numbers without decimal places.
Decimal Number: Used for numbers with decimal places.
Date/Time: Used for dates and times. Power BI has a special data type for Date/Time values, allowing for easy manipulation and visualization of temporal data.
Boolean: Used for true/false or yes/no values.
Currency: Similar to the decimal number data type but specifically formatted for monetary values.
Percentage: A special data type used for representing percentages.
Image URL: Used for storing URLs linking to images. Power BI can display images directly when provided with a valid URL.
Geographical Data: Power BI also supports special data types for geographical data, such as latitude and longitude coordinates.