SWITCH Evaluates an expression against a list of values and returns one of multiple possible result expressions.


SWITCH(expression, value, result[, value, result]…[, else])


Expression – Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).

Value – A constant value to be matched with the results of expression.

Result – Any scalar expression to be evaluated if the results of expression match the corresponding value.

Else – Any scalar expression to be evaluated if the result of expression doesn’t match any of the value arguments.

Return Value

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.

Reference Data


DAX Functions / Logical Functions / SWITCH