SWITCH function in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SWITCH function do in Power BI?

The SWITCH function checks an expression against a list of values and returns the result corresponding to the first matching value. If no match is found, it can return a default value.

beginner

Write the basic syntax of the SWITCH function.

SWITCH(<expression>, <value1>, <result1>, <value2>, <result2>, ..., [<default>])

intermediate

How does SWITCH differ from nested IF statements?

SWITCH is easier to read and write when checking one expression against many values, while nested IFs can become complex and harder to manage.

intermediate

Can SWITCH handle multiple conditions that are not based on a single expression?

No, SWITCH evaluates one expression and compares it to values. For multiple unrelated conditions, nested IF or other functions are better.

beginner

What happens if no match is found and no default value is provided in SWITCH?

SWITCH returns BLANK() if no match is found and no default value is specified.

What is the purpose of the SWITCH function in Power BI?

A To compare one expression to multiple values and return a matching result

B To sum values in a column

C To filter rows based on a condition

D To create relationships between tables

SWITCH compares one expression to multiple values and returns the result for the first match.

Which of the following is the correct syntax for SWITCH?

A SWITCH(result1, value1, expression, value2, result2)

B SWITCH(value1, expression, result1, value2, result2)

C SWITCH(expression, value1, result1, value2, result2, default)

D SWITCH(expression, result1, value1, result2, value2)

The correct syntax starts with the expression, followed by value-result pairs, and an optional default.

If SWITCH does not find a matching value and no default is given, what does it return?

A Error

B BLANK()

C Zero

D The first result

SWITCH returns BLANK() when no match and no default value are provided.

Which scenario is best suited for SWITCH instead of nested IFs?

A Checking multiple unrelated conditions

B Filtering rows in a table

C Summing values in a column

D Checking one expression against many possible values

SWITCH is best when you compare one expression to many values.

Can SWITCH evaluate multiple different expressions at once?

A No, it evaluates only one expression

B Only if nested inside IF

C Yes, it can evaluate multiple expressions

D Only with a default value

SWITCH evaluates only one expression and compares it to multiple values.

Explain how the SWITCH function works and when you would use it in Power BI.

Think about choosing from many options based on one question.

Describe the difference between SWITCH and nested IF statements in DAX.

Consider how easy it is to read and write each.