add_time_intelligence
Generate YTD, QTD, MTD, prior-year, and YoY % measures for a base measure using a date column.
Instructions
Generate the standard time-intelligence measure set for a base measure: YTD, QTD, MTD, PY (prior year), and YoY %. Needs a date table column (e.g. Calendar[Date]).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| homeTable | No | home table for the new measures (optional; defaults to the base measure's table) | |
| sessionId | Yes | ||
| dateColumn | Yes | date column, e.g. Calendar[Date] | |
| baseMeasure | Yes | existing base measure, e.g. Total Sales |