Forum Discussion
Solved
Add Value from next Row
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 res...
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 Maybe:
row plus one column =
VAR __Index = [Index]
VAR __Quantity = [Quantity]
VAR __Quantity1 = MAXX(FILTER('Table',[Index] = __Index + 1),[Quantity])
RETURN
__Quantity + __Quantity1
Thank you, Greg_Deckler!