IIF
Description:
It is used to evaluate different branch expressions depending on whether a Boolean condition is true or false.
Syntax:
IIf(Logical_Expression, Expression1, Expression2)
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Logical_Expression | It is a condition that evaluates to true (1) or false (0). It must be a valid MDX logical expression. |
Expression1 | It is used when the logical expression evaluates to true. Expression1 must be a valid MDX expression. |
Expression2 | It is used when the logical expression evaluates to true. Expression2 must be a valid MDX expression. |
Example:
WITH MEMBER [Measures].[Sales Status] AS
IIF([Measures].[Internet Sales Amount] > 100000, "High", "Low")
SELECT
{[Measures].[Internet Sales Amount], [Measures].[Sales Status]} ON COLUMNS,
[Product].[Product Categories].[Category].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]