AnalystReps

DAX practice: Cumulative Metrics: TOTALYTD, TOTALQTD & TOTALMTD

Chapter 15 · 4 questions · included in full access

  1. Question 1 · easy

    Year to date

    Write Sales YTD: running total of [Total Sales] from January 1st to the current date.

    Solve it in your browser

  2. Question 2 · medium

    Quarter to date

    Write QTD Sales: running total of [Total Sales] from the start of each quarter.

    Solve it in your browser

  3. Question 3 · medium

    Month to date

    Write MTD Sales: running total of [Total Sales] from the start of each month.

    Solve it in your browser

  4. Question 4 · easy

    Orders YTD

    Write Orders YTD: cumulative count of [Orders] from January 1st.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing