pbi_create_time_intelligence_pack
Create time-intelligence measures like YTD, MTD, QTD, and YoY from a base measure in Power BI, with automatic dependency handling and optional dry-run to preview changes.
Instructions
Create a family of time-intelligence measures from a base measure.
Default patterns: YTD, MTD, QTD, SPY, YOY, YOY %, MA3. Each generated
measure is named "{base_measure} {suffix}" (e.g. "Sales YTD")
and lives on table (typically the same fact table as the base measure).
Dependency-aware: requesting YOY% automatically adds YOY and SPY
so the whole family resolves.
With format_inherit=True, each measure inherits base_measure's
format string (best-effort lookup on the live model). format_string
overrides that when supplied. Patterns that prescribe their own format
(e.g. YOY % → "0.00%") win unless format_string is explicit.
With dry_run=True no model mutation occurs — the response carries a
plan listing every measure that would be created/updated/skipped.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| dry_run | No | ||
| patterns | No | ||
| overwrite | No | ||
| date_table | Yes | ||
| date_column | Yes | ||
| base_measure | Yes | ||
| format_string | No | ||
| display_folder | No | Time intelligence | |
| format_inherit | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |