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.

Examples

A common use of SWITCH is to match the result of an expression with constant value:

SWITCH (
    [A],
    0, "Zero",
    1, "One",
    2, "Two",
    "Other numbers"
)

However, the argument can be an expression and the initial can be a constant.
By using TRUE as a first argument, SWITCH can replace a list of cascading IF statements.
The following code:

IF (
    [A] > [B], 
    "First case",
    IF ( 
        [A] = [B],
        "Second case",
        IF (
            [A] = 0,
            "Third case",
            "Fourth case"
        )
    )
)

can be written as:

SWITCH (
    TRUE,
    [A] > [B], "First case",
    [A] = [B], "Second case",
    [A] = 0, "Third case",
    "Fourth case"
)

Related functions

Other related functions are:

Last update: Aug 1, 2020 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/switch-function-dax