Running total that adds leftover from previous values

Hello,

I've recently ran into an issue when creating a report.

I'm trying to create a table that looks like this (minus the incorrect by hour column):

It should calculate how many products should be produced for each timerange taking into account production plans for different lines. The thing is it's impossible to create eg. 0,571 of a product so we need to move the leftover from previous timerange to the next one and check if it gives us another product to be produced in the timerange.

I've managed to create a solution using calculated columns but it requires me to create columns for each line and doesn't seem scaleable. What would the optimal solution for this issue be?

I'm attaching the PBIX file with a more detailed explanation, dummy dataset and current unoptimal solution in the link below.

I'd really appreciate some support on this issue.

Link: https://drive.google.com/file/d/1YfGEEc_TvareO0rNfN2vtJVPh6J84Qrl/view?usp=drivesdk

Kind regards,

Damian