topic Re: Specific report, sum of every two rows need to be visable in next column in DAX Commands and Tips

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

ZXXX — Sun, 17 Jul 2022 09:51:56 GMT

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

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

ZXXX — Sun, 17 Jul 2022 09:55:51 GMT

*measure for new column

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

tamerj1 — Sun, 17 Jul 2022 11:40:45 GMT

Hi ZXXX

please provide some sample data along with the expected results.

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

ZXXX — Sun, 17 Jul 2022 17:21:37 GMT

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

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

tamerj1 — Sun, 17 Jul 2022 17:27:58 GMT

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

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

ZXXX — Sun, 17 Jul 2022 19:21:45 GMT

Maybe it will be more visable

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

ZXXX — Sun, 17 Jul 2022 19:33:49 GMT

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

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

ZXXX — Sun, 17 Jul 2022 19:34:32 GMT

Result is water in container

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

tamerj1 — Sun, 17 Jul 2022 19:55:09 GMT

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 )?!

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

ZXXX — Mon, 18 Jul 2022 06:27:47 GMT

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

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

v-zhangti — Wed, 20 Jul 2022 09:55:40 GMT

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.