SWITCH Evaluates an expression against a list of values and returns one of multiple possible result expressions.
Syntax
SWITCH(expression, value, result[, value, result]…[, else])
Parameters
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
https://docs.microsoft.com/en-us/dax/dax-function-reference