Forum Discussion
Solved
Subtracting values in same column until the value becomes 0
Hello Team, I have a data set where i have to subtract value untill its zero can you please help me. I need dax to solve- Please see the data week sale Week1 10 week2 5 week3 ...
Hi,
Thank you for your feedback, and please check the below picture and the attached pbix file.
hi
hi jihwan,
thank you for quick reply. i checked but still it is showing high values instead of burn down till zero, pleaserefer the data i worked on, can you please look into thisd and advise.
Appreciate your help.
| WEEK REVISED SPD | weekin numbers | sale |
| 36-22 | 202236 | 25 |
| 37-22 | 202237 | 17 |
| 38-22 | 202238 | 22 |
| 39-22 | 202239 | 8 |
| 40-22 | 202240 | 16 |
| 41-22 | 202241 | 3 |
| 42-22 | 202242 | 5 |
| 43-22 | 202243 | 10 |
| 44-22 | 202244 | 2 |
| 45-22 | 202245 | 2 |
| 46-22 | 202246 | 3 |
| 47-22 | 202247 | 3 |
| 48-22 | 202248 | 2 |
| 49-22 | 202249 | 6 |
| 50-22 | 202250 | 2 |
| 51-22 | 202251 | 6 |
| 52-22 | 202252 | 3 |
| 53-22 | 202253 | 1 |
| 01-23 | 202301 | 2 |
| 02-23 | 202302 | 1 |
| 03-23 | 202303 | 2 |
| 05-23 | 202305 | 5 |
| 06-23 | 202306 | 2 |
| 07-23 | 202307 | 4 |
| 08-23 | 202308 | 5 |
| 12-23 | 202312 | 4 |
| 13-23 | 202313 | 1 |
| 14-23 | 202314 | 1 |
| 15-23 | 202315 | 1 |
| 17-23 | 202317 | 1 |
| 22-23 | 202322 | 1 |
Hi,
Thank you for your feedback, and please check the below picture and the attached pbix file.
you are awesome, thanks a lot