Total up to date by product

[ahmedismailfourtex]

Hello,
I have table contains product, date quantity.
Then I need to know when my product reached specific quantity for the first time, I mean I will sum the quality date over date until it reach this quantity then I will detect the date.
I appreciate the help.
Thanks ☺?

 

[CyrusTheVirus]

please provide an example(s) of what you're trying to do and please provide additional explanation as well.

 

[ahmedismailfourtex]

that is example of my DAX table
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Product[/TD]
[TD="class: xl65, width: 64"]Quantity[/TD]
[TD="class: xl65, width: 64"]Date[/TD]
[/TR]
[TR]
[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl66, align: right"]1-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]4[/TD]
[TD="class: xl66, align: right"]1-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]1[/TD]
[TD="class: xl66, align: right"]1-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl66, align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl66, align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl66, align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl66, align: right"]3-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]1[/TD]
[TD="class: xl66, align: right"]3-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl66, align: right"]3-Jan[/TD]
[/TR]
</tbody>[/TABLE]

if my target is 5 of quantity

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]a>=5[/TD]
[TD="class: xl65, width: 64, align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD]b>=5[/TD]
[TD="class: xl65, align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD]c>=5[/TD]
[TD="class: xl65, align: right"]3-Jan[/TD]
[/TR]
</tbody>[/TABLE]

is kind of running total, i need to determined when it reached this value.
Thanks

 

[citizenbh]

Try it like this:

Sample File:
https://www.dropbox.com/s/azo823xlh33fsi1/Total up to date by product.xlsx?dl=0

 

[ahmedismailfourtex]

Try it like this:

Sample File:
https://www.dropbox.com/s/azo823xlh33fsi1/Total up to date by product.xlsx?dl=0

Many thanks,
The running total equation helped me.
Thanks again for the help &#55357;&#56842;