Forum Discussion
Solved
DAX: Running Total
Hello, everyone. I hope someone can help me. In a small example I try to describe my problem. These are my data. They show at wich date how many pieces of an article are delivered. I wou...
Roli_Bird Possibly there is a better way. For instance, by making the sequential date list dynamic. But I didn't go so far. The attached file does what you need.
See if you can get it to work on your end.
Thanks for the clarification. I am still willing to be impressed by you and SergeiBaklan though.
Meanwhile, I might as well post my non-answer to the question. Using 365 and the error bars on a scatter chart I got
from the formula
= LET(
deliveredQty, XLOOKUP(date, IF(item=@selected, delivered), qty,0),
SCAN(,deliveredQty,LAMBDA(acc,q,acc+q)))A perfectly good answer, just not to this question (grin)!
My hope is that this formula would remain viable even were it accumulating 100,000 values. Three does not exactly push it to the limits.
Looks nice. The only question, which value is shown for 04 of Apr, 10 or 30?
- Both? Before delivery and after delivery. At least, that was the intent.