Question 1

What are DAX functions used for?

Accepted Answer

Create new information or analyze KPIs from existing data

Answer

Edit data in a table

Answer

Change the formatting of a chart

Answer

Create charts

Question 2

What are the two main categories of DAX formulas?

Accepted Answer

Calculated columns and calculated measures

Answer

Tables and charts

Answer

Reports and dashboards

Answer

Implicit measures and explicit measures

Question 3

Where are calculated columns used?

Accepted Answer

To perform calculations on a row-level basis and store the results in a new column

Answer

To filter data

Answer

To create visualizations

Answer

To perform calculations on a summarized level (e.g. total sales)

Question 4

Where are calculated measures used?

Accepted Answer

To perform calculations on a summarized level (e.g. total sales) without storing the results in a new column

Answer

To format tables

Answer

To filter data

Answer

To create visualizations

Question 5

What is the benefit of using calculated measures over calculated columns?

Accepted Answer

Measures do not increase the file size of the report.

Answer

Measures are easier to create.

Answer

Measures are more flexible for complex calculations.

Answer

Measures are more visually appealing.

Question 6

How are implicit measures created?

Accepted Answer

By dragging a column into the report view

Answer

By formatting a field

Answer

By writing a DAX formula in the formula bar

Answer

By using the slicer pane

Question 7

How are explicit measures created?

Accepted Answer

By writing a DAX formula in the formula bar

Answer

By dragging a column into the report view

Answer

By using the slicer pane

Answer

By formatting a field

Question 8

What is the difference between an implicit and explicit measure?

Accepted Answer

Implicit measures are predefined and explicit measures are user-defined.

Answer

Implicit measures are for text data and explicit measures are for numerical data.

Answer

Implicit measures are hidden and explicit measures are visible.

Answer

Implicit measures are less flexible and explicit measures are more flexible.

Question 9

Which of the following is an example of an arithmetic operator in DAX?

Accepted Answer

SUM

Answer

CONTAINSSTRING

Answer

OR

Answer

AND

Question 10

Which of the following is an example of a comparison operator in DAX?

Accepted Answer

EQUALTO

Answer

SUM

Answer

CONTAINSSTRING

Answer

AVERAGE

Related quizzes

Related quizzes