Forum Discussion
First Record
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
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])
2 Replies
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])Amazing Thank you!
