TOTALYTD, TOTALQTD, TOTALMTD in Power BI - Step-by-Step Guide

Introduction

These functions help you quickly calculate totals for the year, quarter, or month up to a selected date. They solve the problem of manually summing data over time periods in your reports.

When you want to show total sales from the start of the year to today on your dashboard.

When your report needs to display total expenses for the current quarter so far.

When you want to track monthly revenue growth by showing totals from the start of the month.

When comparing year-to-date performance across different products or regions.

When creating time-based KPIs that update automatically as new data arrives.

Steps

Step 1: Open

- Power BI Desktop

Your report and data model are visible on screen

Step 2: Click

- Modeling tab

Modeling options appear in the ribbon

Step 3: Click

- New measure button

A formula bar opens for you to type a DAX expression

Step 4: Type

- Formula bar

The measure is created and added to your Fields list

💡 Use syntax like: Total Sales YTD = TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])

Step 5: Add

- Report canvas

The new measure appears in your visual, showing the total up to the selected date

Before vs After

Before

A sales table with daily sales amounts but no running totals

After

A report visual showing total sales from January 1st to the selected date, updating automatically as the date changes

Settings Reference

Date column

📍 Inside the TOTALYTD, TOTALQTD, TOTALMTD function as the second argument

Defines the timeline to calculate totals up to the selected date

Default: None

Filter expression

📍 Optional third argument in the functions

Allows you to limit the calculation to specific data subsets

Default: No filter

Common Mistakes

Using a non-date column as the date argument

The functions require a proper date column to calculate time periods correctly

Use a dedicated date column with continuous dates in your data model

Not having a proper date table marked as Date Table

Without a marked date table, time intelligence functions may give incorrect results

Create and mark a date table in Power BI for accurate calculations

Summary

TOTALYTD, TOTALQTD, and TOTALMTD calculate running totals for year, quarter, and month respectively.

They require a proper date column and work best with a marked date table.

Use these functions to create dynamic time-based totals that update automatically in your reports.