cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## How to calculate Spill and accumulated data

Hi everyone, i want to caculate spill from previous hour and add into the next hour and calculate accumulated data for next hour.

Spill = Demand - Capacity + Previous hour accumulated

Accumulated Data = Capacity - (spill from previous hour+  Demand)

 DateTime Hour Rate Resources Capacity Demand Spill ? Accumulated ? 2021-09-06 14:00:00 2.8 5 14 2.25 -11.75 0 2021-09-06 15:00:00 2.8 5 14 2.5 -11.75 0 2021-09-06 16:00:00 2.8 5 14 2.5 -11.75 0 2021-09-06 17:00:00 2.8 2 5.6 2.5 -3.1 0 2021-09-06 18:00:00 2.8 2 5.6 12.5 6.9 6.9 2021-09-06 19:00:00 2.8 2 5.6 0 1.3 1.3 2021-09-06 22:00:00 2.8 6 16.8 20 4.5 4.5 2021-09-06 23:00:00 2.8 6 16.8 1.25 -11.5 0 2021-09-07 00:00:00 2.8 6 16.80 1.25 2021-09-07 01:00:00 2.8 6 16.80 4.25 2021-09-07 02:00:00 2.8 6 16.80 3.75 2021-09-07 03:00:00 2.8 6 16.80 7.75

1 ACCEPTED SOLUTION
Community Support

Hi @AryaS,

You cannot calculate the result.

This is because the first second result is based on the first result, the third result is based on the second result, and that result is such.

However, the first and second results do not exist. The DAX expressions are analyzed on the basis of the available data.

You can reach this result by Excel.

Best Regards

Community Support Team _ chenwu zhu

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

Community Support

Hi @AryaS,

You cannot calculate the result.

This is because the first second result is based on the first result, the third result is based on the second result, and that result is such.

However, the first and second results do not exist. The DAX expressions are analyzed on the basis of the available data.

You can reach this result by Excel.

Best Regards

Community Support Team _ chenwu zhu

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