Microsoft Certified Data Analyst Associate DAX Formulas and Functions 2

Question 1

What does the FILTER function return in DAX?

Accepted Answer

A filtered table based on a condition

Answer

A single filtered value

Answer

A boolean TRUE/FALSE result

Answer

The count of rows matching a condition

Question 2

Which DAX function returns the number of rows in a table or the number of non-blank values in a column?

Accepted Answer

COUNTROWS

Answer

COUNTA

Answer

COUNT

Answer

COUNTBLANK

Question 3

What does the EARLIER function do in DAX?

Accepted Answer

References an outer row context within a nested row context iteration

Answer

Returns the earlier of two dates

Answer

Filters to earlier time periods

Answer

Returns the first value in a sorted column

Question 4

What is context transition in DAX?

Accepted Answer

The process where CALCULATE converts a row context into an equivalent filter context

Answer

Switching between Import and DirectQuery modes

Answer

Moving measures between tables

Answer

Transitioning from one date period to another

Question 5

Which DAX function returns a table with all combinations of values from multiple columns?

Accepted Answer

CROSSJOIN

Answer

UNION

Answer

INTERSECT

Answer

CONCATENATE

Question 6

What does the HASONEVALUE function return in DAX?

Accepted Answer

TRUE if the specified column has exactly one value in the current filter context

Answer

The single value in a filtered column

Answer

TRUE if a column has no blank values

Answer

The count of distinct values in a column