DAX Formulas and Functions Flashcards
6 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 DAX Formulas and Functions flashcards as text
What does the DAX time intelligence function TOTALYTD() calculate?
Answer: The cumulative total from the start of the year to the current date in context
TOTALYTD() calculates the cumulative total of an expression from the beginning of the current year through the last date in the current filter context.
Which DAX function returns the same period from the previous year?
Answer: SAMEPERIODLASTYEAR()
SAMEPERIODLASTYEAR() returns a set of dates shifted one year back, allowing year-over-year comparisons.
What does the DAX function RANKX() do?
Answer: Returns the ranking of a value within a specified table expression
RANKX() returns the rank of an expression evaluated over a table, useful for ranking products, customers, or regions by a measure.
What is 'filter context' in DAX?
Answer: The set of active filters from slicers, rows, columns, and report filters that affect a DAX calculation
Filter context in DAX is the combination of all active filters — from slicers, page filters, visual filters, and row/column headers — that constrain what data a measure evaluates.
What is 'row context' in DAX and in which situations does it exist?
Answer: The current row being iterated in a calculated column or iterator function like SUMX
Row context exists during calculated column evaluation and inside DAX iterator functions like SUMX, giving access to the current row's values.
What does the DAX function HASONEVALUE() return?
Answer: TRUE if the specified column has exactly one distinct value in the current filter context
HASONEVALUE() returns TRUE when exactly one distinct value is visible in a column under the current filter context, often used for conditional formatting or label display.