Question 1

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

Accepted Answer

To evaluate a series of conditions and return a result when a match is found.

Answer

To convert data types.

Answer

To switch data sources dynamically.

Answer

To toggle between different report pages.

Question 2

Which parameter types can be passed as the first argument in the SWITCH function?

Accepted Answer

An expression or a scalar value.

Answer

Only integer values.

Answer

Only column names.

Answer

Only Boolean expressions.

Question 3

How does the SWITCH function handle cases when no conditions are matched?

Accepted Answer

It returns the result specified in the default argument, if provided.

Answer

It returns blank.

Answer

It throws an error.

Answer

It repeats the last successful condition.

Question 4

What is a key benefit of using SWITCH over nested IF functions?

Accepted Answer

Improved readability and potentially better performance.

Answer

Lower memory usage.

Answer

More functions can be nested.

Answer

It is usable in DirectQuery mode only.

Question 5

In the context of DAX, which type of result can SWITCH not return?

Accepted Answer

An array.

Answer

A table.

Answer

A string.

Answer

A scalar value.

Question 6

When implementing SWITCH, what is a common mistake that can affect performance?

Accepted Answer

Overly complex expressions in the value arguments.

Answer

Using too few cases.

Answer

Not using a default case.

Answer

Including an ELSE statement.

Question 7

What is the correct syntax for a SWITCH function that checks for multiple conditions in Power BI?

Accepted Answer

SWITCH(Expression, Value1, Result1, Value2, Result2, ..., DefaultResult)

Answer

SWITCH(Value1, Result1, Value2, Result2, Expression)

Answer

SWITCH([Column], "Value1", "Result1", "Value2", "Result2")

Answer

SWITCH(Value1, Expression1, ..., DefaultResult)

Question 8

Which scenario is most suitable for using the SWITCH function?

Accepted Answer

When there are multiple possible outcomes based on the value of a single expression.

Answer

When calculating aggregate functions.

Answer

When creating a new calculated column with a single condition.

Answer

When filtering data based on user input.

Question 9

What happens if the SWITCH function's expression does not match any case and no default is provided?

Accepted Answer

It returns a blank result.

Answer

It automatically calculates an average.

Answer

It returns the last value checked.

Answer

It stops the report from rendering.

Question 10

What is the difference between SWITCH and the IF function in terms of input handling?

Accepted Answer

SWITCH can handle multiple conditions without nesting, whereas IF requires nesting for more than two conditions.

Answer

SWITCH only accepts Boolean conditions.

Answer

SWITCH is limited to text comparisons.

Answer

IF can evaluate multiple conditions in parallel.

Related quizzes

Related quizzes