Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Waiting line dax calculation

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 processedcapacityProcessedwaiting line
9091090
1101110101
1211310103
1531810108
1081810108
981710107
Need Help
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.