Waiting line dax calculation

[Anonymous]

Hi guys,

Im am trying to achieve the following. I need to calculate the waiting line. 
Whatever is left of the previous row needs to be added to the current row. Hope anyone can point me in the right direction. 

Whatever cannot be processed on the same row, simply moves to thje next row.

influx	remaining from previous row	Total to be processed	capacity	Processed	waiting line
9	0	9	10	9	0
11	0	11	10	10	1
12	1	13	10	10	3
15	3	18	10	10	8
10	8	18	10	10	8
9	8	17	10	10	7

[v-stephen-msft]

Hi @Anonymous ,

How can I get the Processed waiting line? Please provide the calculation process.

Do you want to move the current row to the next row?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Can you explain with an example. Not able to get the number you want in 3rd column

[Anonymous]

Hi Amitchandak,

It is basically a simple waiting line, whoever cannot be processed within the given time, moves to the next block (row  in this exapmle. ) I have added some columns and I hope it makes it a little more clear now.