Power BI 778 DAX Formulas and Calculations 2

Question 1

What does the RELATED function do in DAX?

Accepted Answer

Returns a value from a related table along the many-to-one side

Answer

Creates a new relationship between tables

Answer

Filters related rows from another table

Answer

Joins two tables on a common key

Question 2

What is the purpose of the DIVIDE function in DAX?

Accepted Answer

Divides two numbers safely, returning an alternate result if denominator is zero

Answer

Divides two numbers and returns an error if denominator is zero

Answer

Rounds a division result to two decimal places

Answer

Converts a fraction to a percentage

Question 3

Which DAX function returns the number of distinct values in a column?

Accepted Answer

DISTINCTCOUNT

Answer

COUNT

Answer

COUNTUNIQUE

Answer

COUNTDISTINCT

Question 4

What does the EARLIER function do in DAX?

Accepted Answer

References an outer row context in a nested row context iteration

Answer

Returns a value from the previous row in a table

Answer

Calculates values from the prior year

Answer

Returns the earliest date in a column

Question 5

Which DAX function returns a table with duplicate rows removed?

Accepted Answer

DISTINCT

Answer

FILTER

Answer

VALUES

Answer

UNIQUE

Question 6

What is evaluation context in DAX?

Accepted Answer

The set of filters and row iteration state that determines how a DAX expression is evaluated

Answer

The database where DAX queries run

Answer

The order in which DAX functions execute

Answer

The visual where a measure is displayed