RollingSum
RollingSum(expr, n, grain) · Time intelligence
A rolling window of n grain-periods ("day" | "week" | "month" | "quarter" | "year") ending at each bucket. Missing periods count as zero, not skipped — the window runs over a gap-complete series of buckets, so a month with no sales still advances the window. Additivity rules match YTD (SQX015).
Example
Section titled “Example”Revenue12mRolling := RollingSum([Revenue], 12, "month")