Conditional Expressions

Analysis Services

Analysis Services

Conditional Expressions

Another capability in Multidimensional Expressions (MDX) is the ability to create conditional expressions, expressions that return different information depending upon a decision made in the calculated member based on the existence of a condition.

The following topics discuss the various conditional expressions in use in MDX.

Topic Description
IIf Function Describes the use of the IIf function in MDX expressions for simple decisions.