SWITCH Function (DAX)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Evaluates an expression against a list of values and returns one of multiple possible result expressions.
SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])
Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).
A constant value to be matched with the results of
Any scalar expression to be evaluated if the results of
expression match the corresponding value.
Any scalar expression to be evaluated if the result of
expression doesn't match any of the value arguments.
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.
All result expressions and the else expression must be of the same data type.
The following example creates a calculated column of month names.
=SWITCH([Month], 1, "January", 2, "February", 3, "March", 4, "April"
, 5, "May", 6, "June", 7, "July", 8, "August"
, 9, "September", 10, "October", 11, "November", 12, "December"
, "Unknown month number" )
( 1500 characters remaining)
Thank you for your feedback