- 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 - Logical Operators
You can use DAX logical operators to combine expressions that evaluate to a logical or Boolean value (TRUE or FALSE), to produce a single result that is logical (TRUE or FALSE).
| Logical Operator | Logical Operation | Evaluation |
|---|---|---|
| ! | NOT | It is a unary operator. This means it takes only one operand. The result is −
|
| && | AND | TRUE only if both the expressions are TRUE. Otherwise, FALSE. |
| || | OR | FALSE only if both the expressions are FALSE. Otherwise, TRUE. |
Examples
- ! (1 = 1) results in FALSE, because 1 = 1 is TRUE.
- ! (1 <> 1) results in TRUE, because 1 <> 1 is FALSE.
- (1 = 1) && (5>4) results in TRUE, because both are TRUE.
- (5>4) && (5 = 4) results in FALSE, because 5 = 4 is FALSE.
- (1 = 1) || (5 = 4) results in TRUE, because 1 = 1 is TRUE.
- (2 = 4) || (5 = 4) results in FALSE, because both are FALSE.
excel_dax_operators.htm
Advertisements