SWITCH DAX Function (Logical)
Returns different results depending on the value of an expression.
Syntax
SWITCH ( <Expression>, <Value>, <Result> [, <Value>, <Result> [, … ] ] [, <Else>] )
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
The expression to be evaluated. |
|
| Value | Repeatable |
If expression has this value the corresponding result will be returned. |
| Result | Repeatable |
The result to be returned if Expression has corresponding value. |
| Else | Optional |
If there are no matching values the Else value is returned. |
Return values
Scalar A single value of any type.
A scalar value coming from one of the Result expressions, if there was a match with Value, or from the Else expression, if there was no match with any Value.
Remarks
All result expressions and the else expression must be of the same data type.
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/switch-function-dax