Add Value from next Row

Question

Hello,&nbsp;I'm having diffulty creating a calculated column that would add the Quantity from the current row value and the next row's value.&nbsp; Please see table below with expected result vs actual result:&nbsp;&nbsp;&nbsp;Expected ResultActual ResultIndexQuantityQty + next rowQty + next row1142114272114314241441046145364014644147010148102014910251410155414113942141232691413266433141416716714&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This is my logic:row plus one = calculate(sum('Table'[Quantity]),filter( all('Table'),'Table'[Index]&gt;=SELECTEDVALUE('Table'[Index])&amp;&amp; 'Table'[Index]&lt;=SELECTEDVALUE('Table'[Index])+1 ))&nbsp;Any help will be greatly appreciated.&nbsp;&nbsp;&nbsp;

greg_deckler · Accepted Answer

JeanMariePBI&nbsp;Maybe:
row plus one column =
  VAR __Index = [Index]
  VAR __Quantity = [Quantity]
  VAR __Quantity1 = MAXX(FILTER('Table',[Index] = __Index + 1),[Quantity])
RETURN
  __Quantity + __Quantity1

Forum Discussion

Add Value from next Row

2 Replies

Related content

Closing value

remove duplicate value within a row

IF Negative value

DAX for calculating retroactive values

Handling Null Values

		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