First Record

[sovereignauto]

Afternoon, 

So i have 1 table: 

ID - DateTime - User - Type - Ref

and a 2nd table: 

Ref - ( plus lots of columns)

what i need to do is return the "user" from Table1 as a column in Table2 where Ref = "Ref" AND Type = "AACN" AND is the Earliest from the DateTime column, there can be multiple records with the same ref in Table1 

[amitchandak · Accepted solution]

@sovereignauto , Try a new column in table 2 like

new column =
var _min = Minx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN"), Table1[DateTime])
return
Maxx(filter(Table1, Table1[ref] = Table2[ref] && Table1[Type] = "AACN" && Table1[DateTime] =_min), Table1[user])

[sovereignauto]

Amazing Thank you!