How to calculate Spill and accumulated data

[Anonymous]

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

[v-chenwuz-msft · Accepted solution]

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.