Previous Row from Max Row

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

Hi @Allison_Romero1

Does this link help you ?

2 Likes

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

2 Likes