An Introduction to Calculation Groups in Power BI Desktop
summary
Calculation groups are now native in Power BI Desktop (preview) and replace the need for external tools by letting a model define reusable items like time intelligence (Current, MTD, YTD, Previous Year) applied to any measure. Demo uses the AdventureWorks model, builds a field-parameter slicer to switch measures, adds a calculation-date group to swap relationships (order/ship/due date), and applies dynamic format strings. Claim: instead of 100 measures × 10 variants, create ~110 DAX items. All examples are built live and work in the report visuals.
AI-written summary · about
chapters (8)
- 0:00Introduction to session
- 1:10Understanding the core concept
- 3:19Setting up calculation groups
- 5:51Time intelligence implementation
- 9:46Using field parameters
- 11:56Advanced calculation logic
- 16:28Date-based calculation layers
- 18:16Use cases and wrap-up
related talks
51mPower BI Composite and Hybrid Models
01h 03mBudgeting with Power Pivot
18mEmpowering Business Through Data
54mData Visualization with Power View and the Tabular Model
02h 12mOptimizing your Power Pivot models using Power Query
45mRebooting your SME Data Analysis Strategy
48mDon't be scared with Hybrid, they are only tables…
59mSelf-Service Data Modeling