Please help me to solve how to calculate the negative cumulative

[Anonymous]

[HarishKM]

@Anonymous Hey 

Try this dax 

RT1 =

CALCULATE(SUM(Test[Value]),DATESYTD(Test[Date]))

Output:

Kudos will be appriciated 

[Anonymous]

Thank you very much for the answers of the two above, but my data only has the "value" column, and the following "expect" is the result I want, the value I want to take, so neither of the two answers can solve my problem Of course, I am still very grateful. I hope someone can help me solve this problem. I searched other posts on the forum. One person also had this problem, but it didn’t seem to be solved.

[jaideepnema]

Hi @Anonymous ,
Create a calculated column like this :

Cumulaative Negative = 

var previousvaalue=CALCULATE(SUM('Table'[expect]),FILTER('Table','Table'[Date]=EARLIER('Table'[Date],1)-1))

return IF(('Table'[value]+previousvaalue)<0,'Table'[value]+previousvaalue,0)

This will give you the desired result:

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀