MDX Case Statement Examples for SQL Server Analysis Services

The Case statement exists in many programming languages and it is also available when writing MDX for SQL Server Analysis Services cubes. There are two types of Case statements that can be used in MDX; the simple case and the search case. In this tip we will cover how each of these can be used when writing MDX code.