cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

3 REPLIES 3
Impactful Individual

@Anonymous Hey

Try this dax

RT1 =
CALCULATE(SUM(Test[Value]),DATESYTD(Test[Date]))
Output:

Kudos will be appriciated

Anonymous
Not applicable

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.

Solution Sage

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:

Appreciate a Kudos 😀