How do I reference the value of the previous row?

[hiroyuki_ikuma]

I am creating a weight recording application.
I want to use a virtual column to find the increase/decrease value from the previous record, but it doesn’t work.

LOOKUP([_ROWNUMBER]-1, “log”, “_ROWNUMBER”, “weight”)

I tried the above formula, but it didn’t work.

[Rifad]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

[mfakhreddine · Accepted solution]

Try this:

LOOKUP([_THISROW].[_RowNumber]-1, “log”, “_RowNumber”, “weight”)

[hiroyuki_ikuma]

Wow!
It worked.
Thank you!

[mfakhreddine]

Welcome!

[Thanarat]

It's not working.

Please check

[anthropaulogy]

I am building a similar app, and was having a similar problem.  I tried your selected solution, but it was only getting the last row of the table for some reason.  I tried this, and it is seeming to get the job done.

LOOKUP(MAXROW("Measurements", "Weight (lb)", [Date] < [_THISROW].[Date]), "Measurements", "Measurements ID", "Weight (lb)")