Question 1

Which DAX function is NOT required to have a date table for proper functionality?

Accepted Answer

DATESYTD

Answer

DATESINPERIOD

Answer

EARLIER

Answer

CALCULATE

Question 2

You want to calculate the total sales for the previous quarter. Which function would you use?

Accepted Answer

PREVIOUSQUARTER

Answer

YEARQTD

Answer

DATESQTD

Answer

QUARTERTODATE

Question 3

How can you dynamically compare sales for the current month to the same month last year?

Accepted Answer

VAR lastYear = DATEADD(YEAR,-1,SELECTEDVALUE(DateTable[Date])) CALCULATE(SUM(SalesTable[Sales]), DATESBETWEEN(DateTable[Date], lastYear, ENDOFMONTH(lastYear)))

Answer

SAMEPERIODLASTYEAR combined with DATESYTD

Answer

DATESYTD

Answer

FILTER(SalesTable, DateTable[Date] >= TODAY())

Question 4

What is the primary benefit of using DAX Time Intelligence functions?

Accepted Answer

Simplifying complex date calculations

Answer

Formatting dates for visualizations

Answer

Enabling dynamic comparisons across time periods

Answer

All of the above

Question 5

A custom calendar table can be used for:

Accepted Answer

Defining custom fiscal years

Answer

Both A and B

Answer

Neither A nor B (uses existing date table)

Answer

Specifying holidays for time-based calculations

Question 6

You accidentally filtered your report to a specific month. Which function can help you return to the original date context?

Accepted Answer

ALL

Answer

SELECTEDVALUE

Answer

ALLSELECTED

Answer

REMOVEFILTERS

Question 7

Which of the following functions would be most appropriate to calculate the closing balance for the previous year?

Accepted Answer

CLOSINGBALANCEYEAR

Answer

YEARTODATE

Answer

DATESYTD

Answer

PREVIOUSYEAR

Question 8

When using DAX Time Intelligence functions within a measure, how does the filter context impact the results?

Accepted Answer

The calculations consider all data in the model by default.

Answer

There is no concept of filter context within DAX.

Answer

Filters have no impact on time intelligence calculations.

Answer

The calculations are dynamic and adjust based on slicers and filters applied in the report.

Question 9

What is the difference between DATESBETWEEN and DATESINPERIOD?

Accepted Answer

DATESBETWEEN allows specifying a specific start and end date, while DATESINPERIOD uses predefined periods like quarters or years.

Answer

DATESBETWEEN is for comparing current and previous periods, while DATESINPERIOD is for calculations within a single period.

Answer

There is no functional difference between these functions.

Answer

Neither function is related to time intelligence.

Question 10

How can you calculate the running total of sales for the year to date?

Accepted Answer

SUMX(DATESYTD(DateTable[Date]), CALCULATE(SUM(SalesTable[Sales]), EARLIER(DateTable[Date])))

Answer

There is no built-in DAX function for running totals.

Answer

VAR lastDate = TODAY() CALCULATE(SUM(SalesTable[Sales]), DATESBETWEEN(DateTable[Date], STARTOFYEAR(DateTable[Date]), lastDate))

Answer

YTD.SUM

Related quizzes

Related quizzes