Time Intelligence Calculation Group Creation

Update Time Intelligence Calculation Group Creation.csx

new calculation items MAT, MAT-1, MAT vs MAT-1, MAT vs MAT-1 (%)

Creation of a Time Intelligence Calc Group

In this new release annotations enable other scripts to reference tables and columns specified by the user or the output calc group and calc table.

Time Intel Calculation Group Creation

this new release includes prompts for all parameters

Time Intel Calculation Group Creation

This latest release will prompt you to select fact table, date table etc from your model, reducing the number of parameters to set up and making it posslble to use as a macro and even place in custom toolbar if your are happy with the names for the calc group and the measures it creates.

Time Intel Calculation Group Creation

This release includes the flag to avoid breaking format strings defined by lower precedence calculation groups

Time Intel Calculation Group Creation

This new version includes 2 measures that can work as dynamic labels in some scenarios
instead of PY and CY you can show the user the actual years

Time Intel Calculation Group Creation

It also creates a calculated table to store the names of affected measures

Time Intel Calculation Group Creation

This new release includes the possibility to specify a list of measure names that will be affected by the calculation group.
This goes around the limitation on tabular editor that only measures from the same table can be selected simultaneously.,

Time Intel Calculation Group Creation

If script is run selecting one or more measures, the calc group will only act on those measures.
Otherwise calc group will act on all measures in the filter context.

Time Intel Calculation Group Creation

This script creates a Time Intelligence Calculation Group based on the definitions of daxpatterns.com