Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 3 of 6 · 16 guided hours

DAX for Business Measures

Write DAX measures for business KPIs, understand filter context and compare periods.

Learning objectives

  • Write measures and know when to use calculated columns
  • Use CALCULATE and understand filter context
  • Write time-intelligence measures for period comparisons

Topics

  • measures vs calculated columns
  • SUM, DIVIDE, COUNTROWS
  • filter context
  • CALCULATE
  • time intelligence
  • KPI glossary

Lessons

  1. Lesson 1 Measures and Calculated Columns

    Write basic measures and understand when a calculated column is appropriate.

    measurecalculated columnSUM and COUNTROWSDIVIDE

  2. Lesson 2 CALCULATE and Filter Context

    Understand filter context and use CALCULATE to change it for comparisons and shares.

    filter contextCALCULATEALLshare of total

  3. Lesson 3 Time Intelligence

    Compare periods with year-to-date, previous month and previous year measures.

    TOTALYTDDATEADD and SAMEPERIODLASTYEARmonth-on-month changedate table requirement

Practical activity

Write the solution's KPI measures — sales, budget, variance, margin, year-to-date and month-on-month change — and check each independently.

Expected outcomes

  • Correct, reusable KPI measures
  • Documented KPI definitions

Assessment

Measures checked against independent Excel calculations, plus a KPI glossary review.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.