Power BI 778 DAX Formulas and Calculations 2

Question 1

What does the RELATED function do in DAX?

Accepted Answer

Returns a value from a related table along the many-to-one side

Answer

RELATED retrieves a value from a column in a related table, traversing the relationship from the many side to the one side.

Question 2

What is the purpose of the DIVIDE function in DAX?

Accepted Answer

Divides two numbers safely, returning an alternate result if denominator is zero

Answer

DIVIDE safely handles division by zero by returning an optional alternate result instead of throwing an error.

Question 3

Which DAX function returns the number of distinct values in a column?

Accepted Answer

DISTINCTCOUNT

Answer

DISTINCTCOUNT counts the number of unique, non-blank values in a column.

Question 4

What does the EARLIER function do in DAX?

Accepted Answer

References an outer row context in a nested row context iteration

Answer

EARLIER accesses the value of a column in an outer row context when two nested row iterations are active.

Question 5

Which DAX function returns a table with duplicate rows removed?

Accepted Answer

DISTINCT

Answer

DISTINCT returns a one-column table containing all unique values from the specified column, excluding duplicates.

Power BI 778 Practice Test