Excel DAX - Comparison Operators
Advertisements
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 |
excel_dax_operators.htm
Advertisements