Microsoft Certified Data Analyst Associate DAX Formulas and Functions 3

Question 1

What is the purpose of the VAR keyword in DAX?

Accepted Answer

To declare a variable and store an expression result for reuse within a formula

Answer

VAR declares a named variable within a DAX expression, storing an intermediate result to improve readability and avoid repeated computation.

Question 2

Which DAX function returns a table of unique values from a column?

Accepted Answer

DISTINCT

Answer

DISTINCT returns a one-column table of unique values from a specified column, excluding duplicates but not blank.

Question 3

What does the SWITCH function do in DAX?

Accepted Answer

Evaluates an expression against a list of values and returns the corresponding result

Answer

SWITCH evaluates an expression, compares it to a list of values, and returns the result associated with the first match, similar to a CASE statement.

Question 4

What is the difference between SUMX and SUM in DAX?

Accepted Answer

SUMX iterates a table row by row using an expression; SUM aggregates a single column directly

Answer

SUMX iterates each row of a table, evaluates an expression per row, and sums the results, while SUM simply totals a column's values.

Question 5

What does BLANK() represent in DAX?

Accepted Answer

A null/missing value that propagates through calculations

Answer

BLANK() represents the absence of a value (similar to NULL), and most DAX functions treat blank as zero in arithmetic but as missing in text operations.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate DAX Formulas and Functions 3