| title | AND (DMX) | Microsoft Docs |
|---|---|
| ms.date | 06/07/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | dmx |
| ms.topic | conceptual |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
[!INCLUDEssas-appliesto-sqlas]
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)