cancel
Showing results for
Did you mean:
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!

3 REPLIES 3
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

Proud to be a Datanaut!

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?"

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

Announcements

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!

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?

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