cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pmoto Frequent Visitor
Frequent Visitor

Running SUM formula in DAX

Hello, 

 

I am new here and have a small amount of experince with Power BI. I have read a few threads about creating a formula in DAX for a running sum, but it is not working for me. From the screenshot below I need the "Measured Energy Inj/WD" to have a running sum for "Measurment Day (Display)." Another trick I need is to have it key of the "Meter Number' field and the "Facility" which is in another table that I have a relationship with in Power BI. Hopefully my this my logic makes sense. Let me know if I need to explain it a little better. Any help would be greatly appreciated!2018-09-14_8-57-16.jpg2018-09-14_9-01-16.jpg

3 REPLIES 3
Super User IV
Super User IV

Re: Running SUM formula in DAX

Can you post that text form that can be copied and pasted? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, a running sum formula generally takes the form of:

 

Amount running total in Date = 
CALCULATE(
	SUM('Sample'[Amount]),
	FILTER(
		ALLSELECTED('Sample'[Date]),
		ISONORAFTER('Sample'[Date], MAX('Sample'[Date]), DESC)
	)
)

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Pmoto Frequent Visitor
Frequent Visitor

Re: Running SUM formula in DAX

Hi Greg, I am not sure what you mean by "can you post that text form that can be copied and pasted?"

zoloturu New Contributor
New Contributor

Re: Running SUM formula in DAX

Hi @Pmoto,

 

It is not fully clear on which result do you want to achieve. Can you create a small prototype within Excel and paste it here as an image or text?

 

Regards,
Ruslan

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors