Help with LOOKUPVALUE

Edirin Hmm, worked perfectly fine for me, see attached PBIX. Perhaps trying to do a Trim and Clean in Power Query for all of your columns to remove trailing whitespaces, etc. See attached PBIX below signature.

Hi, Edirin ;

You could try create a column by dax.

Line Manager Name = CALCULATE(MAX('Table1'[Employee Name]),FILTER('Table1',[Employee ID]=EARLIER(Table2[Line Manager Employee ID])))

Or

Column = LOOKUPVALUE('Table1'[Employee Name],Table1[Employee ID],'Table2'[Line Manager Employee ID])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.