Time Intelligence Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Create Model Calculations with DAX

What you'll be asked

  1. Which DAX function is the standard requirement to enable time intelligence calculations in Power BI?
  2. If you want to calculate the total sales for the same period in the previous year, which DAX function should you use?
  3. What is the primary difference between using TOTALYTD and DATESYTD in a DAX measure?
  4. When using the DATEADD function to compare performance, what does the 'interval' parameter represent?
  5. You are creating a moving average for the last 3 months. Why might your calculation return unexpected results if you use DATESINPERIOD without considering the filter context?

Answers and explanations come after you submit.