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

CALCULATE evaluates a DAX expression while applying one or more filters to modify the current filter context.

Question 2

Which DAX function returns the sum of a column?

Accepted Answer

SUM

Answer

SUM takes a single column argument and returns the sum of all values in that column within the current filter context.

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 removes all filters from a table or columns, while ALLEXCEPT removes filters from all columns except those listed.

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

RELATED traverses a many-to-one relationship to retrieve a value from a column in a related table for the current row context.

Question 5

Which DAX function calculates year-to-date totals?

Accepted Answer

TOTALYTD

Answer

TOTALYTD evaluates an expression from the beginning of the year to the last date in the current filter context.

Microsoft Certified Data Analyst Associate Practice Test