Question 1

What is DAX used for in Power BI?

Accepted Answer

A formula language to define calculated columns and measures

Answer

A data cleaning tool

Answer

A data import tool

Answer

A data visualization tool

Question 2

How is DAX different from Excel formulas?

Accepted Answer

DAX is designed specifically for working with data models in tables, while Excel formulas are designed for worksheets.

Answer

DAX cannot perform calculations on text data.

Answer

DAX uses a different syntax than Excel formulas.

Answer

DAX is slower than Excel formulas.

Question 3

How do you create a calculated column in Power BI using DAX?

Accepted Answer

Go to the Modeling tab, select the table, and click on New Column. Enter your DAX formula in the formula bar.

Answer

DAX cannot be used to create calculated columns in Power BI.

Answer

Right-click on a column header and select Create Calculated Column. Enter your DAX formula in the dialog box.

Answer

Go to the Insert tab, click on Calculated Column, and enter your DAX formula.

Question 4

What is the difference between calculated columns and measures in Power BI?

Accepted Answer

Calculated columns are added to a table and evaluated once, while measures are evaluated at the time they are used and are not stored in the data model.

Answer

Calculated columns can be used in visualizations, while measures cannot.

Answer

Calculated columns are more complex to create than measures.

Answer

Measures can only be used with numeric data.

Question 5

How do you create a measure in Power BI using DAX?

Accepted Answer

Go to the Modeling tab, select the table, and click on New Measure. Enter your DAX formula in the formula bar.

Answer

Right-click on a blank area in the report view and select Create Measure. Enter your DAX formula in the dialog box.

Answer

DAX cannot be used to create measures in Power BI.

Answer

Go to the Analyze tab, click on New Measure, and enter your DAX formula.

Question 6

Provide an example of using a filter function in a DAX formula to count the number of rows in a specific category.

Accepted Answer

SUMX(FILTER(, = "internet"), COUNTAROWS(

))

Answer

COUNTIF(, = "internet")

Answer

FILTER(, = "internet").Count

Answer

COUNTROWS(FILTER(, = "internet"))

Question 7

What is the SUMX function used for in DAX?

Accepted Answer

To perform a sum over a table, evaluating a given expression for each row and then returning the sum of all the results.

Answer

To filter a table based on a specific condition.

Answer

To calculate the average of a column in a table.

Answer

To create a new calculated column in a table.

Question 8

How does the CALCULATE function differ from the CALCULATE TABLE function in DAX?

Accepted Answer

The CALCULATE function modifies the filter context within an existing formula, while CALCULATE TABLE creates a new table based on the existing filter context.

Answer

The CALCULATE function is used for calculations on measures, while CALCULATE TABLE is used for calculations on columns.

Answer

CALCULATE TABLE can only be used with date tables.

Answer

CALCULATE is faster than CALCULATE TABLE.

Question 9

How do you use the RANKX function in DAX to rank items in a descending order?

Accepted Answer

RANKX(, , DESC)

Answer

RANK(, , DESC)

Answer

RANKX(, , ASC)

Answer

You cannot rank items in descending order with RANKX.

Question 10

What is the SWITCH function used for in DAX?

Accepted Answer

To evaluate a series of expressions and return a corresponding result based on the first matching expression.

Answer

To perform calculations on dates in a table.

Answer

To create a hierarchy in a Power BI report.

Answer

To filter a table based on multiple conditions.

Related quizzes

Related quizzes