| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
AND (DMX) |
AND (DMX) |
minewiskan |
owend |
owend |
02/17/2022 |
sql |
analysis-services |
reference |
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)