add_semiadditive_measures
Create opening/closing balance measures and last/first non-blank values over a date column. Solve inventory and account-balance reporting by generating semi-additive calculations automatically.
Instructions
Generate semi-additive balance measures (opening/closing balance, last/first non-blank) over a value column and date column - the standard inventory / account-balance pattern.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | home table | |
| sessionId | Yes | ||
| dateColumn | Yes | date column as Table[Column] | |
| valueColumn | Yes | value column as Table[Column] |