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

The total for the last 12 months

Answer

The total for the current year only, ignoring slicers

Answer

The year-over-year growth percentage

Question 2

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

Accepted Answer

SAMEPERIODLASTYEAR()

Answer

PREVIOUSYEAR()

Answer

PARALLELPERIOD()

Answer

DATEADD()

Question 3

What does the DAX function RANKX() do?

Accepted Answer

Returns the ranking of a value within a specified table expression

Answer

Assigns a sequential row number to a table

Answer

Sorts a column in ascending order

Answer

Counts the number of rows above a threshold

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

The color filter applied to a visual

Answer

The WHERE clause written in Power Query

Answer

The row limit applied to a table visual

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

The current row number in a visual table

Answer

The filter applied by row-level security

Answer

The row header in a matrix visual

Question 6

What does the DAX function HASONEVALUE() return?

Accepted Answer

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

Answer

TRUE if a column has no blank values

Answer

The single value from a column when filtered

Answer

TRUE if a measure returns a non-zero value