Calculation groups

Concept

Calculation groups are a tabular model feature that applies reusable DAX calculation items, such as time intelligence, to many measures and so reduces redundant measures.

Title graphic: Calculation groups (Concept)

Type	Concept
Documentation	learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups

Key points about Calculation groups

Calculation groups remove endless YTD, QTD and TTM measure variants and centralize time intelligence. · Build Reusable Semantic Models in Microsoft…

Episodes about Calculation groups

Build Reusable Semantic Models in Microsoft Fabric

2025-08-12 · Video on YouTube

Most Power BI environments start fast and stall under copy-paste sprawl: duplicated PBIX files, conflicting measures, and “spreadmart” dashboards that nobody fully trusts. The fix isn’t another naming convention—it’s a model-first architecture. Microsoft…

Articles about Calculation groups (1)

Mastering Model-First Architecture in Microsoft Fabric
2026-08-28 · Mirko Peters
Welcome back to the podcast and our companion blog! If you have been following our recent discussions, you know how crucial it is to design modern data platforms th…

Frequently asked questions

What problem do calculation groups solve?

Calculation groups replace the many separate YTD, QTD and TTM measure variants with one reusable definition. That keeps time intelligence, KPIs and business rules centralized and auditable rather than copied across reports. · From the episode: Build Reusable Semantic Models in Microsoft…

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Documentation: learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups
Feed for this topic (RSS): entity/calculation-groups/feed.xml
M365.FM episodes on this topic: 1
Articles on this topic: 1

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03