Question 1

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

Accepted Answer

To return different values based on a specified expression.

Answer

To change data types.

Answer

To switch between reports.

Answer

To create a new table.

Question 2

Which DAX function is often compared to the SWITCH function due to its conditional logic?

Accepted Answer

IF

Answer

FILTER

Answer

CALCULATE

Answer

SUM

Question 3

In a SWITCH function, what does the expression parameter define?

Accepted Answer

The value to evaluate.

Answer

The logical condition.

Answer

The default value.

Answer

The result of the SWITCH function.

Question 4

What happens if no value matches the expression in the SWITCH function and no else parameter is provided?

Accepted Answer

It returns BLANK.

Answer

It returns the first value.

Answer

It returns an error.

Answer

It returns zero.

Question 5

Can the SWITCH function be nested within another SWITCH function?

Accepted Answer

Yes

Answer

Only in measures.

Answer

Only in calculated columns.

Answer

No

Question 6

Which parameter in the SWITCH function specifies the default return value if no match is found?

Accepted Answer

else

Answer

value

Answer

expression

Answer

default

Question 7

How does the SWITCH function handle data type mismatches between the expression and the result values?

Accepted Answer

It returns an error.

Answer

It ignores the mismatch.

Answer

It converts data types.

Answer

It returns BLANK.

Question 8

Can the SWITCH function be used in calculated columns?

Accepted Answer

Yes

Answer

No

Answer

Only in tables.

Answer

Only in measures.

Question 9

What is a common use case for the SWITCH function in Power BI?

Accepted Answer

Creating dynamic measures

Answer

Cleaning data

Answer

Merging tables

Answer

Importing data

Question 10

Which of the following is NOT a valid syntax for the SWITCH function?

Accepted Answer

SWITCH (expression, value1, result1)

Answer

SWITCH (expression)

Answer

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

Answer

SWITCH (expression, value1, result1, else)

Question 11

How does the SWITCH function differ from the IF function in handling multiple conditions?

Accepted Answer

SWITCH is more concise for multiple conditions.

Answer

SWITCH can only handle numeric conditions.

Answer

IF can only handle text conditions.

Answer

IF is faster.

Question 12

In the context of SWITCH function, what is meant by "expression"?

Accepted Answer

The value to evaluate and match against case values.

Answer

A column reference.

Answer

A constant value.

Answer

The resulting value of the function.

Question 13

Which of the following is a correct example of a SWITCH function?

Accepted Answer

SWITCH (TRUE(), 1, "One", 2, "Two", "Other")

Answer

SWITCH (1, TRUE(), 2, FALSE())

Answer

SWITCH (TRUE(), "One", 2, "Two")

Answer

SWITCH (1, "One", 2, "Two", "Other")

Question 14

Can the SWITCH function be used to handle text values?

Accepted Answer

Yes

Answer

Only with dates

Answer

No

Answer

Only in numeric contexts

Question 15

What is a potential drawback of using nested IF statements instead of the SWITCH function?

Accepted Answer

Nested IF statements can be more complex and harder to read.

Answer

IF cannot be used in measures.

Answer

SWITCH cannot handle text values.

Answer

Nested IF statements are faster.

Question 16

How can you improve the performance of complex conditional logic in Power BI?

Accepted Answer

Use SWITCH instead of multiple IF statements.

Answer

Use CALCULATE instead.

Answer

Avoid using conditional logic.

Answer

Use nested IF statements.

Question 17

Which of the following best describes the SWITCH function's ability to handle multiple data types in its result values?

Accepted Answer

It can handle multiple data types in its result values.

Answer

It cannot handle numeric values.

Answer

It must use a single data type.

Answer

It cannot handle text values.

Question 18

In Power BI, where can you apply the SWITCH function?

Accepted Answer

In measures, calculated columns, and calculated tables.

Answer

Only in measures.

Answer

Only in calculated columns.

Answer

Only in calculated tables.

Question 19

What is the benefit of using the SWITCH function for time intelligence calculations?

Accepted Answer

Simplifies the logic for multiple time periods.

Answer

It's the only function that works for dates.

Answer

It can't be used for time intelligence.

Answer

It's faster than using IF.

Question 20

How does SWITCH handle logical operations compared to IF?

Accepted Answer

SWITCH evaluates each case sequentially until a match is found.

Answer

IF is always faster than SWITCH.

Answer

SWITCH evaluates all cases at once.

Answer

SWITCH cannot handle logical operations.

Related quizzes

Related quizzes