Question 1

1. When would you use the CALCULATETABLE function in Power BI?

Accepted Answer

When you need to filter a table with specific conditions and return a new table

Answer

When you need to calculate a measure across a different date context

Answer

When you need to merge two tables

Answer

When you want to change the aggregation type in a visualization

Question 2

2. How can the SWITCH function in Power BI improve performance over multiple IF conditions?

Accepted Answer

It evaluates expressions sequentially until a match is found, reducing unnecessary evaluations

Answer

It allows for more complex logic in a single expression

Answer

It can handle more conditions than IF functions

Answer

It can be used across multiple columns at once

Question 3

3. What would be an ideal scenario to use the SWITCH function?

Accepted Answer

When you need to assign different values based on specific categorical data

Answer

When you need to aggregate data over a time period

Answer

When you need to perform a nested IF condition

Answer

When you need to filter rows in a table based on multiple conditions

Question 4

4. Which of the following is NOT a benefit of using CALCULATETABLE?

Accepted Answer

It simplifies the process of applying filters to tables

Answer

It automatically adjusts filters based on user interactions

Answer

It can be used to aggregate data from multiple tables

Answer

It allows dynamic filtering based on context

Question 5

5. In a real-life scenario, how would you use the SWITCH function to categorize sales data?

Accepted Answer

By assigning categories like "High", "Medium", "Low" based on sales thresholds

Answer

By filtering data to show only specific product categories

Answer

By calculating the total sales over time

Answer

By merging sales data from multiple regions

Question 6

6. What happens if none of the conditions in a SWITCH function match?

Accepted Answer

The SWITCH function returns a specified default value

Answer

It automatically selects the first condition

Answer

It displays a blank value

Answer

The function returns an error

Question 7

7. Why might you prefer CALCULATETABLE over using a filter within a visualization?

Accepted Answer

CALCULATETABLE allows for more complex filtering logic that can be reused across multiple visualizations

Answer

Filters in visualizations do not support advanced DAX expressions

Answer

Filters in visualizations are static and cannot be dynamically updated

Answer

CALCULATETABLE is faster in processing large datasets

Question 8

8. How can SWITCH be used effectively in a dashboard where different user roles need to see different data?

Accepted Answer

By switching between different datasets based on user roles

Answer

By filtering data for specific user roles

Answer

By hiding certain visuals based on user permissions

Answer

By aggregating data based on role-specific conditions

Question 9

9. What is a limitation of using the SWITCH function?

Accepted Answer

It cannot handle complex boolean logic like AND or OR within conditions

Answer

It requires a specific default value to function properly

Answer

It can only handle numeric data types

Answer

It cannot be used in calculated columns

Question 10

10. In what situation would you use CALCULATETABLE within a nested SWITCH function?

Accepted Answer

When you need to apply dynamic filters within different conditional cases

Answer

When you want to merge data from different sources based on conditions

Answer

When you want to calculate a measure for a specific condition

Answer

When you need to switch between different table aggregations

Related quizzes

Related quizzes