Season 2

Namaste Power BI

Episode 22

Calculation Groups

⏱ 45:00

Episode Summary

Calculation groups — a modeling feature that applies time intelligence or formatting dynamically to ANY measure. One slicer controls YTD, MTD, PY across all measures simultaneously.

This is Episode 22 of the free Namaste Power BI course on DevWithData — covering calculation groups. Watch the video above, then pass the MCQ checkpoint to unlock the next episode and update your Data Readiness Index score.

Key Takeaways

→Calculation groups apply reusable logic to multiple measures via SELECTEDMEASURE()
→One calculation group can replace dozens of duplicate time measures
→Created in external tools (Tabular Editor) and imported into the model
→Calculation groups interact with format strings for conditional formatting

⚠ Common Interview Pitfalls

•Calculation groups with multiple items can conflict with each other
•Not understanding precedence when multiple calculation groups exist
•Forgetting that calculation groups change how measures evaluate globally

Official Reference

Deepen your understanding with official Microsoft documentation.

PL-300 Official Training Course

Microsoft's official instructor-led training for the Power BI Data Analyst certification.

https://learn.microsoft.com/en-us/training/courses/pl-300t00

Power BI Documentation

Complete reference for Power BI Desktop, Power BI Service, and Power BI Embedded.

https://learn.microsoft.com/en-us/power-bi/

Content on DevWithData is original and inspired by official Microsoft resources. The links above point directly to Microsoft Learn — always the authoritative source.

← Ep 21: Variables & Debugging

Ep 23: Performance Optimization →

Episode Checkpoint

Sign in to attempt the quiz and unlock the next episode.