Formulas and measures

Calculated columns, measures, filter context, time intelligence and the full function reference.

• AI assistanceDescribe what you want; the result is verified before it is offered.
• Calculated columns vs measuresThe single most important distinction in the formula engine — and the mistake almost everyone makes first.
• How the formula builder worksBlocks instead of text, checked as you build — and why the engine has no formula parser at all.
• Writing your first measureA worked example, from a total to a share of total.
• Filter context: ignoring filters on purposeHow to widen a measure past the chart it sits in — the basis of every "share of total" calculation.
• Window calculationsRunning totals, shares, differences, moving averages and rank, computed along the axis.
• Time intelligenceYear-to-date, quarter-to-date, month-to-date, and comparisons with last year.
• Quick measuresCommon shapes, pre-built, editable afterwards.
• Organising measuresFolders, naming, and keeping a growing model navigable.
• Function referenceEvery function, aggregation and window calculation, with signatures and examples.