Excel DAX - Comparison Operators

You can use the DAX comparison operators to compare two values producing a result that is a logical value, i.e. either TRUE or FALSE. DAX supports the following comparison operators.

Comparison Operator Comparison Operation Example Result
= Equal to 5 = 4 FALSE
> Greater than 5>4 TRUE
< Less than 5<4 FALSE
>= Greater than or equal to 5>=3 TRUE
<= Less than or equal to 3<=5 TRUE
<> Not equal to 5<>4 TRUE
Kickstart Your Career

Get certified by completing the course

Get Started