Calculation groups
Calculation groups are a data modeling feature that enable common expression logic to be centralized and leveraged by other measures when needed in reports. In this section, we cover the creation of the same basic date intelligence from the previous section, Date intelligence metrics, but use calculation groups.
In the previous section, we covered the creation of basic date intelligence metrics for Internet Net Sales. However, supporting eight common date intelligence expressions for each of 24 base measures would imply adding 192 (8*24) distinct measures to the dataset, thus adding both development time and complexity for report authors and analysts. Calculation groups address this issue by allowing report authors to reuse common expressions such as year-to-date for whichever base measure it’s needed for.
Calculation groups allow the creation of general calculation formulas that can be applied to any explicit measure within the data model. Thus...
