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

Multiplies all the numbers in a column.

Answer

Subtracts all the numbers in a column.

Question 2

Which DAX function is used to calculate the total sales over a given period?

Accepted Answer

TOTALYTD()

Answer

TOTALQTD()

Answer

SUM()

Answer

COUNT()

Question 3

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

Accepted Answer

Modifies the filter context of a formula.

Answer

Finds the maximum value in a column.

Answer

Sums up all the values in a column.

Answer

Divides one column by another.

Question 4

How do you write a DAX formula to find the average of a column named 'Revenue'?

Accepted Answer

AVERAGE(Revenue)

Answer

SUM(Revenue) / COUNT(Revenue)

Answer

AVG(Revenue)

Answer

TOTAL(Revenue)

Question 5

What does the RELATED() function do in DAX?

Accepted Answer

Fetches a value from another related table.

Answer

Concatenates two columns.

Answer

Filters data based on criteria.

Answer

Calculates a running total.

Question 6

How would you use DAX to calculate a column's total only for the current year?

Accepted Answer

TOTALYTD(SUM([Column]), "12/31")

Answer

CURRENTYEAR([Column])

Answer

YEAR([Column])

Answer

SUM([Column])

Question 7

Which function allows you to count rows that contain a specific condition or filter?

Accepted Answer

COUNTROWS()

Answer

SUM()

Answer

COUNT()

Answer

FILTER()

Question 8

How is the FILTER() function used in a DAX formula?

Accepted Answer

It applies a filter to the data used in a calculation.

Answer

It sums filtered data.

Answer

It merges tables based on filters.

Answer

It counts the number of filtered entries.

Question 9

What function would you use to return the current date in a DAX formula?

Accepted Answer

TODAY()

Answer

NOW()

Answer

DATE()

Answer

DAY()

Question 10

What is the function to concatenate two columns in DAX?

Accepted Answer

CONCATENATE()

Answer

COMBINE()

Answer

APPEND()

Answer

MERGE()

Question 11

Which function would you use to find the median of a numeric column in DAX?

Accepted Answer

MEDIAN()

Answer

MID()

Answer

AVERAGE()

Answer

CENTER()

Question 12

How do you calculate year-over-year growth using DAX?

Accepted Answer

([Current Year Value] - [Previous Year Value]) / [Previous Year Value]

Answer

SUM([Current Year]) / SUM([Previous Year]) - 1

Answer

GROWTH([Current Year], [Previous Year])

Answer

[Current Year] - [Previous Year]

Question 13

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

Accepted Answer

To reference an earlier row context in calculations.

Answer

To get previous day’s data.

Answer

To revert changes in a calculation.

Answer

To sort data in ascending order.

Question 14

What DAX function do you use to return unique values in a column?

Accepted Answer

DISTINCT()

Answer

SINGULAR()

Answer

VALUES()

Answer

UNIQUE()

Question 15

Which function can dynamically rank items based on their performance?

Accepted Answer

RANKX()

Answer

INDEX()

Answer

SORT()

Answer

ORDER()

Question 16

How would you calculate the number of non-empty values in a column using DAX?

Accepted Answer

COUNTA()

Answer

COUNTBLANK()

Answer

NONBLANK()

Answer

COUNT()

Question 17

What function helps in creating a time intelligence calculation, like comparing this month's sales to last month's?

Accepted Answer

DATEADD()

Answer

YEAREND()

Answer

DATEDIFF()

Answer

MONTHCHANGE()

Question 18

How do you create a conditional column in DAX?

Accepted Answer

IF()

Answer

SWITCH()

Answer

DECIDE()

Answer

CASE()

Question 19

What function would you use for a running total in a specific order?

Accepted Answer

CUMULATE()

Answer

TOTAL()

Answer

SEQUENCE()

Answer

RUNNINGTOTAL()

Question 20

What is a DAX function that could be used to format dates?

Accepted Answer

FORMAT()

Answer

DATE()

Answer

TEXT()

Answer

DATEFORMAT()

Related quizzes

Related quizzes