Question 1

What is the purpose of the EARLIER function in DAX?

Accepted Answer

To refer to the value of an earlier row context

Answer

To create time intelligence functions

Answer

To filter a table for earlier periods

Answer

To perform calculations on earlier dates

Question 2

How can you create a calculated column that shows the cumulative total of sales by month?

Accepted Answer

CALCULATE(SUM(Sales[SalesAmount]), FILTER(ALL(Sales), Sales[Date] <= EARLIER(Sales[Date])))

Answer

TOTALYTD(SUM(Sales[SalesAmount]), Sales[Date])

Answer

SUMX(Sales, Sales[SalesAmount])

Answer

CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Sales[Date]))

Question 3

What function would you use to calculate the rank of a product based on sales within a category?

Accepted Answer

RANKX(ALL(Sales), Sales[SalesAmount], , DESC, DENSE)

Answer

RANKX(Sales, Sales[SalesAmount], , DESC, DENSE)

Answer

RANK(Sales[SalesAmount])

Answer

RANK.EQ(Sales[SalesAmount])

Question 4

How can you handle many-to-many relationships in DAX?

Accepted Answer

Use the CROSSFILTER function to manage the relationship

Answer

Use the USERELATIONSHIP function to create temporary relationships

Answer

Use the RELATEDTABLE function to combine tables

Answer

Use the BLANK function to remove duplicates

Question 5

What is the difference between ALL and ALLSELECTED functions?

Accepted Answer

ALL ignores any filters on the table, while ALLSELECTED respects user selections

Answer

ALLSELECTED ignores all filters applied by the user

Answer

ALLSELECTED removes row context filters

Answer

ALL respects user selections, while ALLSELECTED removes all filters

Question 6

How do you create a measure that calculates the sales growth from the previous year?

Accepted Answer

(SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Sales[Date])))/CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Sales[Date]))

Answer

CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Sales[Date]))

Answer

(SUM(Sales[SalesAmount]) - SUM(Sales[SalesAmount])) / SUM(Sales[SalesAmount])

Answer

SUMX(Sales, Sales[SalesAmount]) - SUM(Sales[SalesAmount])

Question 7

What function would you use to return the last non-blank value in a column?

Accepted Answer

LASTNONBLANK

Answer

LASTDATE

Answer

LASTVALUE

Answer

LASTBLANK

Question 8

How can you calculate the total sales for the last 3 months dynamically?

Accepted Answer

CALCULATE(SUM(Sales[SalesAmount]), DATESINPERIOD(Sales[Date], LASTDATE(Sales[Date]), -3, MONTH))

Answer

CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Sales[Date]))

Answer

TOTALMTD(SUM(Sales[SalesAmount]), Sales[Date])

Answer

DATESBETWEEN(Sales[Date], -3, TODAY())

Question 9

Which function helps to retrieve the value from a related table?

Accepted Answer

Answer

RELATEDTABLE

Answer

LOOKUPVALUE

Answer

EARLIER

Question 10

How can you handle missing values in DAX calculations?

Accepted Answer

Use the COALESCE function

Answer

Use the BLANK function

Answer

Use the ISBLANK function

Answer

Use the IFERROR function

Question 11

What is the role of the CALCULATETABLE function?

Accepted Answer

To return a table modified by the filters

Answer

To create table relationships

Answer

To create calculated columns in tables

Answer

To perform aggregations on tables

Question 12

How can you apply a filter to a table only during a calculation without modifying the report filter?

Accepted Answer

Use the FILTER function within CALCULATE

Answer

Use the USERELATIONSHIP function

Answer

Apply the filter directly to the report

Answer

Use the ALL function to remove existing filters

Question 13

How can you find the earliest date in a column?

Accepted Answer

MIN

Answer

FIRSTDATE

Answer

STARTDATE

Answer

EARLIER

Question 14

What is the purpose of the CONTAINS function in DAX?

Accepted Answer

To check if a table contains a specific value

Answer

To create a logical condition

Answer

To concatenate strings

Answer

To filter a table based on a condition

Question 15

How can you count distinct values in a column?

Accepted Answer

DISTINCTCOUNT

Answer

COUNTA

Answer

COUNT

Answer

DISTINCT

Question 16

What is the use of the PATH function in DAX?

Accepted Answer

To return a delimited text string with the identifiers of all the parents of the current identifier

Answer

To generate random paths

Answer

To find the shortest path between two points

Answer

To calculate cumulative totals

Question 17

How can you calculate the average sales per product category?

Accepted Answer

AVERAGEX(VALUES(Product[Category]), [Total Sales])

Answer

AVERAGE(Product[SalesAmount])

Answer

AVERAGEX(Sales, [Total Sales])

Answer

CALCULATE(AVERAGE(Sales[SalesAmount]), Product[Category])

Question 18

How can you create a measure to show the percentage of total sales for each product?

Accepted Answer

DIVIDE(SUM(Sales[SalesAmount]), CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales)))

Answer

SUM(Sales[SalesAmount])/SUMX(Sales, Sales[SalesAmount])

Answer

SUM(Sales[SalesAmount])/TOTAL(Sales[SalesAmount])

Answer

SUMX(Sales, Sales[SalesAmount])/CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales))

Question 19

What function would you use to perform time intelligence calculations for fiscal years?

Accepted Answer

DATESYTD

Answer

TOTALYTD

Answer

DATEADD

Answer

SAMEPERIODLASTYEAR

Question 20

How can you ensure a calculation only includes the data with specific criteria?

Accepted Answer

Use the CALCULATE function with appropriate filters

Answer

Use the IF function to filter the data

Answer

Use the FILTER function alone

Answer

Use the ALL function to remove unwanted data

Related quizzes

Related quizzes