cant lookup value from Var to table in model

[Anonymous]

I am trying to do a lookupvalue.

I have a variable where I have a Key,and I want to search that Key in the employee table.

...

var Final5 =
FILTER(
SUMMARIZE(Union5,'Staff'[Key_Employee],'Date'[Week],"summ", SUM(Staff[Hours])
),
[summ]>10
)


Var final = SUMMARIZE(union (final1,final2,final3,final4,final5), 'Staff'[Key_Employee])

Now, I want to return:

return ADDCOLUMNS(final,  LOOKUPVALUE(Employee[Name],Employee[Key_Employee], final[Key_Employee] 

(but this doesnt work...)

neither does

return ADDCOLUMNS(final,  LOOKUPVALUE(Employee[Name],Employee[Key_Employee], 'staff'[Key_Employee] 

How can I achieve it?

[smpa01]

@Anonymous  try this

var Final5 =
FILTER(
SUMMARIZE(Union5,'Staff'[Key_Employee],'Date'[Week],"summ", SUM(Staff[Hours])
),
[summ]>10
)

Var final = SUMMARIZE(union (final1,final2,final3,final4,final5), 'Staff'[Key_Employee])
RETURN ADDCOLUMNS(final,"@Employee.key", MAXX(FILTER(Employee, Employee[Key_Employee]=earlier([Key_Employee)),Employee[Name]))