The last records from another table with conditions

[Julio_Moyano]

HI, 

I have tried to get the last record from another table using MAXROW().

I have this expression:

Select(table[people],AND([position]='Manager',[project]=[_THISROW].[project]))

The problem is that some projects have two or more managers because they can be very long, and I need to know who the final manager is

thanks

[Julio_Moyano · Accepted solution]

I found the solution

LOOKUP(
MAX(
Select(table[_ROWNUMBER],AND([position]='manager',[project]=[_THISROW].[project]))
),
"table",
"_ROWNUMBER",
"people"
)