add_time_intelligence_measures
Generate a full set of time intelligence measures (YTD, QTD, MTD, MoM, YoY, etc.) from a base measure, with optional fiscal year-end and offline PBIP output.
Instructions
Generate the full time-intelligence measure set off a base measure: YTD/QTD/MTD, PY/PM, MoM/YoY (+%), PYTD/YOYTD (+%). fiscalYearEnd (MM-DD, e.g. 06-30) drives fiscal *TD. target=pbip: pass pbipFolder instead of sessionId to write the SAME measures OFFLINE into a PBIP semantic model's TMDL (no engine; collision-checked appends).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | home table for the new measures | |
| dateTable | No | date table name | |
| sessionId | No | sessionId from connect_model (live engine; pass exactly one of sessionId / pbipFolder) | |
| dateColumn | No | date column name on the date table | |
| pbipFolder | No | target=pbip: a PBIP <name>.SemanticModel / TMDL definition folder to edit OFFLINE (engine-free) | |
| baseMeasure | No | base measure name, e.g. Total Sales | |
| fiscalYearEnd | No | fiscal year-end MM-DD (optional, e.g. 06-30) |