Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

HELP! Can't calculate MTD numbers way I want

Hi Everyone!

 

I am trying to calculate MTD total to show it on the graph along with daily numbers. Please refer to the screenshot attached below.

 

So assuming you have seen the screenshot,

 

I want this line, but along with it I want another metric like - on blank it will show 2L, then on 1 it will show 16 L(14+2), then on 2 it shows 32 L (16+16), then on 3 it will show 41 L (32+9) and so on for the whole month.

 

Now the issue is I have tried the MTD formulas available and they only show 41 L on every date instead of incremental MTD as I want.

 

Please help me, I know this is an easy fix but can't figure it out.

 

something like thissomething like this

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors