DAX Practice

DAX Practice Pro

The 8 free lessons cover the core of DAX: filter context, CALCULATE and context transition. Pro carries on from there, with the same model and the same checking.

  • 51 Pro lessons today in 9 modules, graded cell by cell like the free ones
  • From iterators and filter context to time intelligence, ranking, virtual tables and a PL-300 practice test
  • Progress saved to your account, on every device
  • Pay monthly or yearly and cancel any time, or pay once for Lifetime

Lessons in Pro

  1. Averages per customer with AVERAGEX over VALUES
  2. Counting customers with DISTINCTCOUNT
  3. Order lines per customer
  4. The largest order line with MAXX
  5. Counting rows that pass a test
  6. Fix the margin
  7. Sales per selling day
  8. Readable measures with VAR
  9. Only show reliable averages with IF
  10. One value or nothing: SELECTEDVALUE
  11. Tiers with SWITCH(TRUE())
  12. Combining conditions with AND
  13. KEEPFILTERS and filter intersection
  14. FILTER versus a column filter
  15. Share of all customers with REMOVEFILTERS
  16. Share of the visible total with ALLSELECTED
  17. Fix the best-customer measure
  18. Average monthly sales
  19. Counting lines with RELATEDTABLE
  20. Customers who bought a bike
  21. Sales by ship date with USERELATIONSHIP
  22. Products per customer with CROSSFILTER
  23. Average products per customer
  24. Share of the year with a date table
  25. Year to date with TOTALYTD
  26. Year to date with CALCULATE and DATESYTD
  27. Last year with SAMEPERIODLASTYEAR
  28. Year-over-year growth in percent
  29. Previous month with DATEADD
  30. Rolling three months with DATESINPERIOD
  31. Running total over all dates
  32. Ranking products with RANKX
  33. Ranks inside a category, blank in subtotals
  34. Sales of the top 3 products with TOPN
  35. Share of the top 3
  36. Average per customer and year with SUMMARIZE
  37. Customers above average with ADDCOLUMNS
  38. Sales from large customers
  39. Calculation groups, as a concept
  40. Totals that don’t add up
  41. The wrong table iterated
  42. Two filters on one column
  43. Customers without sales
  44. PL-300 practice 1: margin by segment
  45. PL-300 practice 2: share of category
  46. PL-300 practice 3: year to date
  47. PL-300 practice 4: growth versus last year
  48. PL-300 practice 5: top products
  49. PL-300 practice 6: active customers
  50. PL-300 practice 7: ship date analysis
  51. PL-300 practice 8: high-value customers