AnalystReps

DAX practice: Statistical Iterators: AVERAGEX, MINX & MAXX

Chapter 6 · 3 questions · included in full access

  1. Question 1 · medium

    Average order value

    Write Avg Order Value: the average order amount (Units * UnitPrice) across Sales.

    Solve it in your browser

  2. Question 2 · medium

    Max order value

    Write Max Order Value: the largest single order value (Units * UnitPrice) in each region.

    Solve it in your browser

  3. Question 3 · medium

    Min order value

    Write Min Order Value: the smallest single order value (Units * UnitPrice) in each region.

    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