Question 1

Which DAX function can be used to replace multiple nested IF statements in Power BI?

Accepted Answer

SWITCH

Answer

CHOOSE

Answer

LOOKUPVALUE

Answer

CASE

Question 2

In a SWITCH function, what is the maximum number of conditions that can be evaluated?

Accepted Answer

127

Answer

Unlimited

Answer

64

Answer

32

Question 3

What would be the result of a SWITCH function if no conditions are met and no default value is provided?

Accepted Answer

BLANK

Answer

ERROR

Question 4

Which scenario is best suited for using the SWITCH function in DAX?

Accepted Answer

Categorizing a list of customers based on their purchase history

Answer

Calculating a running total

Answer

Creating a calendar table

Answer

Summarizing sales data over time

Question 5

In the SWITCH function, how does the function determine which result to return?

Accepted Answer

It evaluates the expression and returns the result of the first matching value

Answer

It returns the result with the highest value

Answer

It returns the result with the lowest value

Answer

It randomly selects one of the matching results

Question 6

What happens if multiple conditions in a SWITCH function are met?

Accepted Answer

The first matching condition's result is returned

Answer

All matching conditions' results are combined

Answer

The SWITCH function fails

Answer

The last matching condition's result is returned

Question 7

How would you use SWITCH to categorize employees based on their department?

Accepted Answer

Use SWITCH to match department names to specific categories, returning a category for each department

Answer

Use SWITCH to create a pivot table

Answer

Use SWITCH to list all employees alphabetically

Answer

Use SWITCH to calculate the average salary by department

Question 8

What is a key advantage of using the SWITCH function over nested IF statements in DAX?

Accepted Answer

Simplified syntax and easier readability

Answer

Better compatibility with other DAX functions

Answer

Higher performance

Answer

Allows for unlimited conditions

Question 9

In a SWITCH function, which argument is optional?

Accepted Answer

The default result

Answer

None, all arguments are required

Answer

The value to switch on

Answer

The expression to evaluate

Question 10

How can SWITCH function be applied in a data analysis scenario where different discount rates are given based on customer type?

Accepted Answer

By using SWITCH to evaluate the customer type and return the corresponding discount rate

Answer

By using SWITCH to sum up all discount rates

Answer

By using SWITCH to average the discount rates for all customers

Answer

By using SWITCH to calculate the total revenue after applying the discounts

Related quizzes

Related quizzes