DAX Formulas and Calculations Flashcards

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

Answer: FILTER

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

What does the USERELATIONSHIP function do in DAX?

Answer: Activates an inactive relationship for use within a CALCULATE expression

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

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

Answer: SAMEPERIODLASTYEAR

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

What is context transition in DAX?

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

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

What does the HASONEVALUE function return in DAX?

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

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

Which DAX function creates a summary table grouped by specified columns?

Answer: SUMMARIZE

SUMMARIZE creates a grouped summary table by aggregating data over the specified grouping columns.