Microsoft Power BI DAX Formulas and Functions 2

Question 1

What does the DAX time intelligence function TOTALYTD() calculate?

Accepted Answer

The cumulative total from the start of the year to the current date in context

Answer

TOTALYTD() calculates the cumulative total of an expression from the beginning of the current year through the last date in the current filter context.

Question 2

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

Accepted Answer

SAMEPERIODLASTYEAR()

Answer

SAMEPERIODLASTYEAR() returns a set of dates shifted one year back, allowing year-over-year comparisons.

Question 3

What does the DAX function RANKX() do?

Accepted Answer

Returns the ranking of a value within a specified table expression

Answer

RANKX() returns the rank of an expression evaluated over a table, useful for ranking products, customers, or regions by a measure.

Question 4

What is 'filter context' in DAX?

Accepted Answer

The set of active filters from slicers, rows, columns, and report filters that affect a DAX calculation

Answer

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.

Question 5

What is 'row context' in DAX and in which situations does it exist?

Accepted Answer

The current row being iterated in a calculated column or iterator function like SUMX

Answer

Row context exists during calculated column evaluation and inside DAX iterator functions like SUMX, giving access to the current row's values.

Microsoft Power BI Practice Test

Microsoft Power BI Practice Test

Microsoft Power BI DAX Formulas and Functions 2