cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
akkitek
Helper III
Helper III

Creating a measure to calculate cumulative total in table visual

Hey Everyone,
I am trying to create a measure to calculate a cumulative total in of a summerized table. I created a measure called "Cumulative Budget" to get the cummulative totals of the budget column but it doesn't seem to work. My desired result is to get 10,800 for 8/31, 34,560 for 9/30 and so on. 

akkitek_1-1663621849730.png

 

Here's the link to the test file: https://drive.google.com/file/d/1zrqIqMyksFj-x6hggzSKKP9Xae_sIKMf/view?usp=sharing

Any help is appreciated. Thanks!


 

 

 

1 ACCEPTED SOLUTION
Seanan
Solution Supplier
Solution Supplier

Hi @akkitek 

Try this code:

Budget Running Total = 
CALCULATE(
	SUM('Baseline_Variance'[Budget]),
	FILTER(
		ALLSELECTED('Baseline_Variance'[Baseline End Date]),
		ISONORAFTER('Baseline_Variance'[Baseline End Date], MAX('Baseline_Variance'[Baseline End Date]), DESC)
	)
)

View solution in original post

2 REPLIES 2
Seanan
Solution Supplier
Solution Supplier

Hi @akkitek 

Try this code:

Budget Running Total = 
CALCULATE(
	SUM('Baseline_Variance'[Budget]),
	FILTER(
		ALLSELECTED('Baseline_Variance'[Baseline End Date]),
		ISONORAFTER('Baseline_Variance'[Baseline End Date], MAX('Baseline_Variance'[Baseline End Date]), DESC)
	)
)

This worked! Thanks!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors