Specific report, sum of every two rows need to be visable in next column

[ZXXX]

Hi, 

This i s specific report about water that is save every day 

I need to have info in next column how much water was save from previous day, and how much comes inn, so in fact it is total of every two rows and result need to be visable for every day, please help how to prepare dax for this.

It is quite easy in Excel

Please advice how to prepare measure for new table

[ZXXX]

Maybe it will be more visable

[ZXXX]

DATA	rain (mm)	water from roof	total of rain	need	used water	Total of water in container
12.05.2019	0,1	22,5	22,5		0	4802,5
13.05.2019	0,7	157,5	157,5		0	4960
14.05.2019	8,1	1822,5	1822,5	0	0	6782,5
15.05.2019	15,6	3510	3217,5		0	10000
16.05.2019	7,9	1777,5	0		0	10000
17.05.2019	7,8	1755	0		0	10000

[v-zhangti · Accepted solution]

Hi, @ZXXX 

Please try the following methods.

Column =
4802.5 - 22.5
    + CALCULATE (
        SUM ( 'Table'[total of rain] ),
        FILTER ( 'Table', [DATE] <= EARLIER ( 'Table'[DATE] ) )
    )

(4802.5 - 22.5) represents the initial value.

Best Regards,

Community Support Team _Charlotte

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

[tamerj1]

HI @ZXXX 
I could understand this set of data 

But the latest data is not clear at all. How did you calculate the first value ( 4802,5 )?!

[ZXXX]

The same calculations but from previous days.

The final what I'm trying to do is chartof How much water is in container evey day.

For this I need to add water from previous day, add new one and take off water that was used, taking off is easy.

Thanks for help

[ZXXX]

Result is water in container

[tamerj1]

Hi @ZXXX 

please provide some sample data along with the expected results. 

[ZXXX]

Like I show in Excel screenshoot, total of previous day + number of water that is new for today. Result is G column but it is also part of calculation.

Thanks

[tamerj1]

@ZXXX 
Please provide the same copy/paste so we can use to generate sample file. thank you

[ZXXX]

*measure for new column