Forum Discussion

Pmoto's avatar
Pmoto
New Member
8 years ago

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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)
	)
)
    • Pmoto's avatar
      Pmoto
      New Member
      8 years ago

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

      • zoloturu's avatar
        zoloturu
        Icon for Memorable Member rankMemorable Member
        8 years ago

        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