AND (DMX)
Applies to: 
SQL Server Analysis Services
Performs a logical conjunction on two numeric expressions.
Syntax
Expression1 AND Expression2
Parameters
Expression1
A valid Data Mining Extensions (DMX) expression that returns a numeric value.
Expression2
A valid DMX expression that returns a numeric value.
Return Value
A Boolean value that returns TRUE if both parameters evaluate to TRUE; otherwise FALSE.
Remarks
Both parameters are treated as Boolean values (0 as FALSE; otherwise TRUE) before the operator performs the logical conjunction. The following table lists the values that are returned based on the various combinations of parameter values.
| If Expression1 is | If Expression2 is | Return value is |
|---|---|---|
| TRUE | TRUE | TRUE |
| TRUE | FALSE | FALSE |
| FALSE | TRUE | FALSE |
| FALSE | FALSE | FALSE |
See Also
Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for