Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 5
Total 20
So here the toal sale is 20 and i need the resuls like this
Week Sale
Week1 10 (20-10)
Week2 5 (10-5)
Week3 0 (5-0)
Appreciate your help please
Solved! Go to Solution.
Hi,
Thank you for your feedback, and please check the below picture and the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
you are awesome, thanks a lot
Hi,
I am not sure if I understood correctly your question, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file whether it suits your requirement.
I hope the below can provide some ideas on how to create a solution for your dataset.
Expected measure: =
CALCULATE ( [Sales total:], REMOVEFILTERS () )
- CALCULATE ( [Sales total:], Data[Week] <= MAX ( Data[Week] ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |