Quizalize logo
placeholder image to represent content

DAX Time Intelligence Function in Power BI

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    Which DAX function is NOT required to have a date table for proper functionality?
    DATESINPERIOD
    EARLIER
    DATESYTD
    CALCULATE
    30s
  • Q2
    You want to calculate the total sales for the previous quarter. Which function would you use?
    YEARQTD
    DATESQTD
    PREVIOUSQUARTER
    QUARTERTODATE
    30s
  • Q3
    How can you dynamically compare sales for the current month to the same month last year?
    SAMEPERIODLASTYEAR combined with DATESYTD
    VAR lastYear = DATEADD(YEAR,-1,SELECTEDVALUE(DateTable[Date])) CALCULATE(SUM(SalesTable[Sales]), DATESBETWEEN(DateTable[Date], lastYear, ENDOFMONTH(lastYear)))
    DATESYTD
    FILTER(SalesTable, DateTable[Date] >= TODAY())
    30s
  • Q4
    What is the primary benefit of using DAX Time Intelligence functions?
    Simplifying complex date calculations
    Formatting dates for visualizations
    Enabling dynamic comparisons across time periods
    All of the above
    30s
  • Q5
    A custom calendar table can be used for:
    Both A and B
    Neither A nor B (uses existing date table)
    Specifying holidays for time-based calculations
    Defining custom fiscal years
    30s
  • Q6
    You accidentally filtered your report to a specific month. Which function can help you return to the original date context?
    SELECTEDVALUE
    ALLSELECTED
    REMOVEFILTERS
    ALL
    30s
  • Q7
    Which of the following functions would be most appropriate to calculate the closing balance for the previous year?
    YEARTODATE
    CLOSINGBALANCEYEAR
    DATESYTD
    PREVIOUSYEAR
    30s
  • Q8
    When using DAX Time Intelligence functions within a measure, how does the filter context impact the results?
    There is no concept of filter context within DAX.
    Filters have no impact on time intelligence calculations.
    The calculations consider all data in the model by default.
    The calculations are dynamic and adjust based on slicers and filters applied in the report.
    30s
  • Q9
    What is the difference between DATESBETWEEN and DATESINPERIOD?
    DATESBETWEEN is for comparing current and previous periods, while DATESINPERIOD is for calculations within a single period.
    There is no functional difference between these functions.
    DATESBETWEEN allows specifying a specific start and end date, while DATESINPERIOD uses predefined periods like quarters or years.
    Neither function is related to time intelligence.
    30s
  • Q10
    How can you calculate the running total of sales for the year to date?
    SUMX(DATESYTD(DateTable[Date]), CALCULATE(SUM(SalesTable[Sales]), EARLIER(DateTable[Date])))
    There is no built-in DAX function for running totals.
    VAR lastDate = TODAY() CALCULATE(SUM(SalesTable[Sales]), DATESBETWEEN(DateTable[Date], STARTOFYEAR(DateTable[Date]), lastDate))
    YTD.SUM
    30s

Teachers give this quiz to your class