Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@Anonymous Hey
Try this dax
Kudos will be appriciated
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.
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 😀
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |