Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

anmolmalviya05
Super User
‎05-21-2025 09:00 AM

Power BI TMDL View: Create a Time Intelligence Calculation Group in Just One Click!

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.

anmolmalviya05_0-1746182216132.png

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.

📺 [Watch the full video here]

 


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.