P&L Financial Statement with Calculation Groups

01Business problem

Finance needed MTD, QTD, YTD, prior-year and variance views for every P&L line. Writing those as separate measures would have meant 60+ measures that all needed maintaining.

02Approach

A general-ledger extract was mapped to a P&L structure table. Calculation groups (Tabular Editor) apply the time-intelligence logic once to a handful of base measures, so the matrix shows Current, YTD, PY and YoY % for every line from one definition.

03What's inside

• Statement matrix: revenue → gross profit → net profit
• Calculation group: Current, MTD, QTD, YTD, PY, YoY %
• Waterfall from revenue to net profit
• Net profit by department and quarter
• Year and department slicers

04Insights & outcome

Model stays small (5 base measures) and any new time view is a one-line change rather than a rewrite.