Forum Discussion

Pmoto's avatar
Pmoto
New Member
7 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 scree...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 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
7 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
    7 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