Syntax
SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])
Tutorial with example
Learn how to use the function SWITCH in DAX/ Powerpivot.
Switch is the equivalent of IF but it has easier syntax and therefore it is easier to read.
Download example file:
Link to excel demo file here.
Remarks
All result expressions and the else expression must be of the same data type.
Was this helpful?
Let us know your thoughts...