SWITCH

« Back to Glossary Index

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.

Links to the mentioned resources

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #15

Remarks

All result expressions and the else expression must be of the same data type.

Practical examples:

Change currency with slicers:

« Back to Index