Previous Row from Max Row

[Allison_Romero1]

Hi I am looking for an expression to refer to a specific row that falls in between MAXROW & MINROW (I know its not correct syntax but something along the lines of either MAXROW -1 or MINROW + 1). There will only be 3 possible rows and there will be 3 different actions needing this specific row data

These are the MAXROW and MINROW formulas for reference:

LOOKUP(MAXROW(“Billing Details”, “_ROWNUMBER”, [ParticipationID] = [_THISROW].[ParticipationID]), “Services”, “ServiceID”, “CPT”)

LOOKUP(MINROW(“Billing Details”, “_ROWNUMBER”, [ParticipationID] = [_THISROW].[ParticipationID]), “Services”, “ServiceID”, “CPT”)

Thank you

[Aurelien · Accepted solution]

Hi @Allison_Romero1

Does this link help you ?

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

Nope. Try: INDEX( ORDERBY( FILTER( "My Table", ([_THISROW].[Thing] = [Thing]) ), [_ROWNUMBER], TRUE ), 2 )

[Allison_Romero1]

Thank you very much, yes it does. I didn’t think of it this way, I was stuck on MAXROW and MINROW.