Question 1

What does the DAX function SUM() do?

Accepted Answer

Adds all the numbers in a column.

Answer

Averages the numbers in a column.

Answer

Subtracts all the numbers in a column.

Answer

Multiplies all the numbers in a column.

Question 2

Which DAX function is used to calculate the total year-to-date sales?

Accepted Answer

TOTALYTD()

Answer

TOTALQTD()

Answer

COUNT()

Answer

SUM()

Question 3

What is the purpose of the CALCULATE() function in DAX?

Accepted Answer

Modifies the filter context of a formula.

Answer

Divides one column by another.

Answer

Sums up all the values in a column.

Answer

Finds the maximum value in a column.

Question 4

How do you write a DAX formula to find the average revenue in a column?

Accepted Answer

AVERAGE(Revenue)

Answer

SUM(Revenue) / COUNT(Revenue)

Answer

TOTAL(Revenue)

Answer

AVG(Revenue)

Question 5

What does the RELATED() function do in DAX?

Accepted Answer

Fetches a value from another related table.

Answer

Calculates a running total.

Answer

Concatenates two columns.

Answer

Filters data based on criteria.

Question 6

Which DAX function would you use to return the maximum value in a column?

Accepted Answer

MAX()

Answer

SUM()

Answer

AVERAGE()

Answer

MIN()

Question 7

How do you create a calculated column that shows the difference between two columns, Sales and Cost, in DAX?

Accepted Answer

Sales - Cost

Answer

Sales + Cost

Answer

Sales / Cost

Answer

Sales * Cost

Question 8

What is the use of the DISTINCT() function in DAX?

Accepted Answer

Returns unique values from a column.

Answer

Returns all values from a column.

Answer

Returns the count of distinct values.

Answer

Returns the sum of distinct values.

Question 9

How do you write a DAX formula to count the number of rows in a table?

Accepted Answer

COUNTROWS(Table)

Answer

COUNTA(Table)

Answer

COUNT(Table)

Answer

COUNTALL(Table)

Question 10

What does the FILTER() function do in DAX?

Accepted Answer

Returns a table with filtered rows.

Answer

Returns the sum of a column.

Answer

Returns a single value.

Answer

Returns the average of a column.

Question 11

How do you write a DAX formula to calculate the cumulative total of a column Sales?

Accepted Answer

TOTALYTD(SUM(Sales), Date)

Answer

CUMSUM(Sales)

Answer

CUMULATIVE(Sales)

Answer

SUM(Sales)

Question 12

What is the function of ALL() in DAX?

Accepted Answer

Removes all filters from a table or column.

Answer

Returns all rows from a table.

Answer

Applies all filters to a table or column.

Answer

Counts all values in a table.

Question 13

How do you create a measure that calculates the total profit in a DAX model where Profit is Revenue - Cost?

Accepted Answer

SUM(Revenue) - SUM(Cost)

Answer

SUM(Revenue - Cost)

Answer

SUMX(Revenue, Cost)

Answer

TOTAL(Revenue - Cost)

Question 14

What does the EARLIER() function do in DAX?

Accepted Answer

Refers to an earlier row context.

Answer

Refers to the previous column.

Answer

Refers to a later row context.

Answer

Refers to the first row.

Question 15

Which function in DAX can be used to create a rolling average of sales over the last 3 months?

Accepted Answer

AVERAGEX(3, Sales)

Answer

AVERAGE(Sales, 3)

Answer

ROLLINGAVG(Sales, 3)

Answer

MOVINGAVG(Sales, 3)

Question 16

How do you write a DAX formula to find the distinct count of customers in a column CustomerID?

Accepted Answer

DISTINCTCOUNT(CustomerID)

Answer

COUNT(CustomerID)

Answer

COUNTDISTINCT(CustomerID)

Answer

COUNTA(CustomerID)

Question 17

What is the function of VALUES() in DAX?

Accepted Answer

Returns a one-column table of unique values.

Answer

Returns the sum of unique values.

Answer

Returns a table with all rows.

Answer

Returns all values in a column.

Question 18

How do you create a measure that shows the percentage of total sales for each product in a DAX model?

Accepted Answer

DIVIDE(SUM(Sales), CALCULATE(SUM(Sales), ALL(Product)))

Answer

SUM(Sales) % TOTAL(Sales)

Answer

PERCENTAGE(Sales, Product)

Answer

SUM(Sales) / TOTAL(Sales)

Question 19

Which DAX function would you use to calculate the year-over-year growth in sales?

Accepted Answer

YOY(Sales)

Answer

YEAROVER(Sales)

Answer

GROWTH(Sales, Year)

Answer

YEARLYGROWTH(Sales)

Question 20

What does the RANKX() function do in DAX?

Accepted Answer

Returns the ranking of a value in a table.

Answer

Returns the rank of a column.

Answer

Returns the average rank of a column.

Answer

Returns the highest value in a column.

Related quizzes

Related quizzes