Power BI TMDL View: Create a Time Intelligence Cal...

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.

📺 [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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment