- Excel DAX Tutorial
- DAX - Home
- DAX - Overview
- DAX - Calculated Columns
- DAX - Calculated Fields / Measures
- DAX - Editing a Calculated Field
- DAX - Deleting a Calculated Field
- DAX - Syntax
- DAX - Operators
- DAX - Standard Parameters
- DAX - Functions
- DAX - Understanding DAX Functions
- DAX - Evaluation Context
- DAX - Formulas
- Updating Results of DAX Formulas
- Updating Data in the Data Model
- DAX - Recalculating DAX Formulas
- Troubleshooting DAX Formula Recalculation
- DAX - Formula Errors
- DAX - Time Intelligence
- DAX - Filter Functions
- DAX - Scenarios
- Performing Complex Calculations
- DAX - Working with Text and Dates
- Conditional Values & Testing for Errors
- DAX - Using Time Intelligence
- DAX - Ranking & Comparing Values
- Excel DAX Useful Resources
- DAX - Quick Guide
- DAX - Useful Resources
- DAX - Discussion
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 |
excel_dax_operators.htm
Advertisements