Add Value from next Row

[JeanMariePBI]

Hello,

I'm having diffulty creating a calculated column that would add the Quantity from the current row value and the next row's value.  Please see table below with expected result vs actual result:

		Expected Result	Actual Result
Index	Quantity	Qty + next row	Qty + next row
1	14	21	14
2	7	21	14
3	14	24	14
4	10	46	14
5	36	40	14
6	4	4	14
7	0	10	14
8	10	20	14
9	10	25	14
10	15	54	14
11	39	42	14
12	3	269	14
13	266	433	14
14	167	167	14

This is my logic:

row plus one = calculate(sum('Table'[Quantity]),filter( all('Table'),'Table'[Index]>=SELECTEDVALUE('Table'[Index])&& 'Table'[Index]<=SELECTEDVALUE('Table'[Index])+1 ))

Any help will be greatly appreciated.

[Greg_Deckler · Accepted solution]

@JeanMariePBI Maybe:

row plus one column =
  VAR __Index = [Index]
  VAR __Quantity = [Quantity]
  VAR __Quantity1 = MAXX(FILTER('Table',[Index] = __Index + 1),[Quantity])
RETURN
  __Quantity + __Quantity1

[JeanMariePBI]

Thank you, Greg_Deckler!