nerdexam
Microsoft

70-466 · Question #88

You need to create a measure for DOD sales. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

The correct answer is A. Specify a date table by using a Mark as Date table. B. Use the Data Analysis Expressions (DAX) PARALLELPERIOD() function.. Creating a Day-Over-Day (DOD) measure in a DAX tabular model requires marking the date table and using a DAX time intelligence function to shift the date context.

Build a tabular data model

Question

You need to create a measure for DOD sales. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

Exhibit

70-466 question #88 exhibit

Options

  • ASpecify a date table by using a Mark as Date table.
  • BUse the Data Analysis Expressions (DAX) PARALLELPERIOD() function.
  • CUse the Business Intelligence Wizard to define time intelligence.
  • DUse the Multidimensional Expressions (MDX) LAG() function.

How the community answered

(51 responses)
  • A
    71% (36)
  • C
    22% (11)
  • D
    8% (4)

Why each option

Creating a Day-Over-Day (DOD) measure in a DAX tabular model requires marking the date table and using a DAX time intelligence function to shift the date context.

ASpecify a date table by using a Mark as Date table.Correct

Marking a table as a Date Table registers it with the DAX engine as the authoritative date table, which is a prerequisite for time intelligence functions to work correctly by enabling proper date context transitions.

BUse the Data Analysis Expressions (DAX) PARALLELPERIOD() function.Correct

PARALLELPERIOD() is a DAX time intelligence function that returns a parallel period offset from the current date context, making it suitable for period-over-period comparisons such as DOD, WOW, or YOY calculations.

CUse the Business Intelligence Wizard to define time intelligence.

The Business Intelligence Wizard is a feature of SSAS Multidimensional models, not DAX tabular models, so it cannot be used to define time intelligence in a Power BI or tabular SSAS context.

DUse the Multidimensional Expressions (MDX) LAG() function.

LAG() is an MDX function used in Multidimensional Expression queries against SSAS Multidimensional cubes, not a DAX function, so it cannot be used in a tabular or Power BI measure.

Concept tested: DAX time intelligence with marked date table

Source: https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax

Topics

#DAX#PARALLELPERIOD#Mark as Date Table#time intelligence

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice