Power BI 778 DAX Formulas and Calculations 3

Question 1

Which DAX function creates a virtual table by filtering an existing table based on a condition?

Accepted Answer

FILTER

Answer

FILTER returns a table that is a subset of another table, keeping only rows that satisfy the specified condition.

Question 2

What does the USERELATIONSHIP function do in DAX?

Accepted Answer

Activates an inactive relationship for use within a CALCULATE expression

Answer

USERELATIONSHIP activates an inactive relationship within the scope of a CALCULATE expression to use an alternate join path.

Question 3

Which DAX function returns the same period from the previous year?

Accepted Answer

SAMEPERIODLASTYEAR

Answer

SAMEPERIODLASTYEAR returns a table of dates shifted one full year back from the current filter context.

Question 4

What is context transition in DAX?

Accepted Answer

Converting row context into filter context when CALCULATE is called inside a row iteration

Answer

Context transition occurs when CALCULATE is called inside a row context, automatically converting that row context into an equivalent filter context.

Question 5

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

HASONEVALUE returns TRUE when the filter context for the specified column results in exactly one distinct value.

Power BI 778 Practice Test