Microsoft Certified Data Analyst Associate DAX Formulas and Functions

Question 1

What does the CALCULATE function do in DAX?

Accepted Answer

Evaluates an expression in a modified filter context

Answer

Performs arithmetic calculations on a column

Answer

Counts rows that meet a condition

Answer

Returns a value from a related table

Question 2

Which DAX function returns the sum of a column?

Accepted Answer

SUM

Answer

SUMX

Answer

TOTAL

Answer

AGGREGATE

Question 3

What is the difference between ALL and ALLEXCEPT in DAX?

Accepted Answer

ALL removes filters from all columns; ALLEXCEPT removes filters from all columns except specified ones

Answer

ALL includes all rows; ALLEXCEPT excludes specified rows

Answer

They are identical functions

Answer

ALL works on tables; ALLEXCEPT works on columns

Question 4

What does the RELATED function do in DAX?

Accepted Answer

Returns a value from a related table following the many-to-one relationship

Answer

Creates a new relationship between tables

Answer

Lists all related tables in the model

Answer

Filters rows based on a related table's values

Question 5

Which DAX function calculates year-to-date totals?

Accepted Answer

TOTALYTD

Answer

DATEYTD

Answer

SUMYTD

Answer

YTDTOTAL

Question 6

What is the purpose of the DIVIDE function in DAX?

Accepted Answer

To safely divide two numbers and return an alternate result if the denominator is zero

Answer

To perform integer division only

Answer

To split a string column by a delimiter

Answer

To divide a table into equal partitions