| title | AND (DMX) |
|---|---|
| description | AND (DMX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | dmx |
[!INCLUDEssas]
Performs a logical conjunction on two numeric expressions.
Expression1 AND Expression2
Expression1
A valid Data Mining Extensions (DMX) expression that returns a numeric value.
Expression2
A valid DMX expression that returns a numeric value.
A Boolean value that returns TRUE if both parameters evaluate to TRUE; otherwise FALSE.
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 |
Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)