add_ibcs_variance_measure
Add IBCS variance measures to a Power BI model, calculating absolute or relative differences between actual and a comparison base (PY, PL, FC), with optional IBCS number formatting.
Instructions
Author IBCS variance measure(s) for an actual measure vs a comparison base (PY|PL|FC). kind=abs (AC - base, leading-sign format) or rel (DIVIDE(AC - base, ABS(base)) %). The base is expected as a measure ' ' unless comparisonMeasure is given. applyIbcsFormat applies an IBCS number format (+/- leading sign).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | No | abs | rel | abs |
| table | Yes | the measure's table | |
| sessionId | Yes | ||
| comparison | No | PY | PL | FC | PY |
| actualMeasure | Yes | the actual measure, e.g. Sales | |
| applyIbcsFormat | No | apply an IBCS number format | |
| comparisonMeasure | No | explicit comparison-base measure name (optional; else '<actual> <comparison>') |