AnalystReps

DAX practice: Period Comparisons: Prior Year & YoY Growth

Chapter 16 · 3 questions · included in full access

  1. Question 1 · easy

    Last year

    Write Sales LY: [Total Sales] evaluated for the same period last year.

    Solve it in your browser

  2. Question 2 · medium

    Orders LY

    Write Orders LY: order count evaluated for the same period in the prior year.

    Solve it in your browser

  3. Question 3 · hard

    Year-over-year growth

    Write YoY %: percentage growth over last year. Guard with IF(NOT ISBLANK(ThisYear), ...).

    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