Compare periods without changing definitions — Smart Study Module 17

A rise in collected rupees is different from a rise in achievement percentage points.

Outcomes

Understand

Calendar contains every day in 2026. Mark it as the date table when using classic time intelligence and relate it to payment_date. Do not construct a calendar using only dates with payments.

February collection rises from ₹48,000 to ₹50,000: absolute change ₹2,000 and relative change 4.1667%. Efficiency rises from 80% to 83.3333%: 3.3333 percentage points, not 3.3333% relative growth.

A January prior-month comparison has no supplied December payment evidence. Explain the missing period instead of presenting an unjustified performance change. POS is still the January snapshot and cannot serve as a two-month trend.

Follow along

  1. Verify Calendar has 365 unique dates for 2026.
  2. Create Prior Month and Growth measures.
  3. Select February and reconcile prior ₹48,000/current ₹50,000.
  4. Write absolute, relative and percentage-point changes separately.

Worked example

Prior Month = CALCULATE([Collection], DATEADD(Calendar[date], -1, MONTH))
Growth = DIVIDE([Collection]-[Prior Month], [Prior Month])

February absolute change=2000; growth=4.1667%; efficiency change=3.3333 percentage points.

Practice

Enter February minus January achievement in percentage points, rounded to two decimals.

Create a free personalized study plan · Download project instructions

Interactive practice runs in your browser.