With the new TMDL View introduced in Power BI, creating reusable and powerful time intelligence logic is easier than ever.
In this blog, I'll walk you through how to create a Calculation Group with just one click using the TMDL syntax – no need to go through Tabular Editor or external tools anymore.
What is a Calculation Group?
A Calculation Group allows you to create reusable logic for commonly used calculations like:
- Year-to-Date (YTD)
- Quarter-to-Date (QTD)
- Month-to-Date (MTD)
- Current Value (no filter applied)
These can be dynamically applied to any measure, drastically reducing duplication and making your model more maintainable.
One-Click Script to Create Time Intelligence Calculation Group
Simply paste the following TMDL script (Copy/ download from here for correct indentation) into the TMDL View.
This script will instantly add a calculation group named Time Intelligence with commonly used items like YTD, QTD, MTD, and Current.
Want to See It In Action?
I've created a detailed step-by-step video walking you through the entire process, including how to use the calculation group in your reports.
I Hope you find this helpful !!
Regards
Anmol Malviya
Proud to be a Microsoft Fabric community super user
Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.
Super User