How to lookup text from one table to another using an inactive relationship

[amolbdesai]

Hi

I need assistance in pulling value in [First Name] column from Table 'Employee master' to a calculated column 'Cal Name' in table 'Table ABC'.

Both tables have [Employee ID] as the common column and an inactive relationship One to on [Employee ID] column exists between 'Employee master' and 'Table ABC'. I cannot setup an active relationship between these two tables.

Thanks

Amol

[FarhanAhmed · Accepted solution]

You can use LookupValue function

Try Below

LookupColumn = LOOKUPVALUE(Table2[Value2],Table2[Column1],Table1[Column1])