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

FILTER returns a table containing only the rows that satisfy the specified Boolean expression.

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

COUNTROWS counts the number of rows in a table or in a table returned by an expression.

Question 3

What does the EARLIER function do in DAX?

Accepted Answer

References an outer row context within a nested row context iteration

Answer

EARLIER accesses the value of a column from an outer row context when working in nested iterations, commonly used in calculated columns with FILTER.

Question 4

What is context transition in DAX?

Accepted Answer

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

Answer

Context transition occurs when CALCULATE converts the current row context into an equivalent filter context, which is critical to understand when using measures in calculated columns.

Question 5

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

Accepted Answer

CROSSJOIN

Answer

CROSSJOIN returns a table that is the Cartesian product of all specified tables, containing every combination of rows.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate DAX Formulas and Functions 2