QTD
Time intelligence
QTD(expr, dateCol)
Exactly YTD scoped to the quarter: accumulates expr from the start of each quarter through each date bucket. Same additivity rules (SQX015), same composition with Calculate (filters, RemoveFilters, prior-period via DateShift).
When to use it
Section titled “When to use it”- Quarter pacing against targets — sales cycles that reset quarterly.
- Chart it at a month/week/day axis; the accumulation resets at each quarter boundary.
Example
Section titled “Example”RevenueQTD := QTD([Revenue], Date.Date)