Author calculation groups

Enabled for Public preview General availability
Users, automatically Oct 11, 2023 -

Business value

Significantly reduce the number of redundant measures by reusing common business logic in complex semantic models. Enhance DAX readability and reduce semantic model maintenance overhead.

Feature details

Calculation groups address an issue in complex models where there can be a proliferation of redundant measures using the same calculations - most common with time intelligence calculations. For example, a sales analyst wants to view sales totals and orders by month-to-date (MTD), quarter-to-date (QTD), year-to-date (YTD), orders year-to-date for the previous year (PY), and so on.

Calculation groups have been part of Power BI as an engine-only feature. With this enhancement, you'll be able to author calculation groups using first-party tooling in Power BI Desktop.

See also

Create calculation groups in Power BI (docs)