Find most recent key from table

[Mrak123]

I currently have this formula:

ANY(SELECT(Backup[Batch Number],([Barcode]=(MAXROW("Backup","_ROWNUMBER")))))

This returns me the [batch number] that correlates with the most recent [Barcode] in the Backup table.

I need this formula to return the [Batch Number] that correlates with the most recent [Barcode] that also has the same USEREMAIL() in the [Listed User Email] column.

Something like this, but this is obviously wrong:

ANY(SELECT(Backup[Batch Number],([Barcode]=AND((MAXROW("Backup","_ROWNUMBER")),([Listed User Email]=USEREMAIL()))))

Any help would be greatly appreciated

[Marc_Dillon · Accepted solution]

Utilize the third parameter of MAXROW for the useremail matching condition.

[Mrak123]

@Marc_Dillon Much appreciated, works a treat. I had seen that on the MAXROW info page but had misunderstood it completely.

For anyone else reading this that wants the solution equation:

ANY(SELECT(Backup[Batch Number],([Barcode]=(MAXROW("Backup","_ROWNUMBER",[Listing User Email]=USEREMAIL())))))