Question 1

What are DAX functions used for?

Accepted Answer

Create new information or analyze KPIs from existing data

Answer

Change the formatting of a chart

Answer

Create charts

Answer

Edit data in a table

Question 2

What are the two main categories of DAX formulas?

Accepted Answer

Calculated columns and calculated measures

Answer

Implicit measures and explicit measures

Answer

Tables and charts

Answer

Reports and dashboards

Question 3

Where are calculated columns used?

Accepted Answer

To perform calculations on a row-level basis

Answer

To filter data

Answer

To perform calculations on an aggregated level

Answer

To create a visualization

Question 4

How are calculated columns created?

Accepted Answer

By entering a formula in the Data View

Answer

By creating a new measure

Answer

By using the Quick Insights feature

Answer

By dragging a field into the Fields section

Question 5

What is an advantage of using calculated measures over calculated columns?

Accepted Answer

Measures do not increase the file size of the report.

Answer

Measures can be used in multiple tables.

Answer

Measures are more visually appealing.

Answer

Measures are easier to create.

Question 6

What is the purpose of implicit measures?

Accepted Answer

Implicit measures are created automatically by Power BI when a column is dragged into a visualization.

Answer

Implicit measures are user-defined formulas that perform complex calculations.

Answer

Implicit measures cannot be used in Power BI.

Answer

Implicit measures are used to filter data.

Question 7

What is the difference between an aggregation function and a DAX function?

Accepted Answer

Aggregation functions are always used with calculated measures, while DAX functions can be used with both calculated columns and measures.

Answer

Aggregation functions are more complex than DAX functions.

Answer

DAX functions cannot be used with calculated measures.

Answer

There is no difference between aggregation functions and DAX functions.

Question 8

What is the IntelliSense feature in Power BI used for?

Accepted Answer

IntelliSense helps you find and autocomplete DAX functions and table names as you type a formula.

Answer

IntelliSense allows you to format your DAX formulas.

Answer

IntelliSense checks your formulas for errors.

Answer

IntelliSense is a charting tool.

Question 9

How can you tell the difference between a calculated column and a measure in Power BI?

Accepted Answer

Calculated columns are listed in the Fields section, while measures are not.

Answer

There is no visual difference between calculated columns and measures.

Answer

Calculated columns are created in the Data View, while measures are created in the Report View.

Answer

Calculated columns are blue, and measures are green.

Question 10

Which of the following is NOT a type of DAX operator?

Accepted Answer

Arithmetic operators

Answer

Comparison operators

Answer

Text operators

Answer

Custom operators

Related quizzes

Related quizzes