Forum Discussion

Edirin's avatar
Edirin
Frequent Visitor
3 years ago
Solved

Help with LOOKUPVALUE

I have 2 tables...

 

Table 1

Employee ID

Employee Name

E001

Jaimie

E002Fred
E003Isaac
E004Jones
E005Billy

 

Table 2

Job IDEmployee IDLine Manager Job IDLine Manager Employee IDLine Manager Name
J001E001   
J002E002J001E001 
J003E003J002E002 
J004E004J002E002 
J005E005J003E003 

 

I was able to populate the Line manager employee ID as follows...

Line Manager Employee ID = LOOKUPVALUE('Table 2'[EmployeeID], 'Table 2'[JobID], 'Job DB'[LineManagerJobID])
 
Now i'm trying to get the line manager name; but doing this just returns blank values (looking up the lookup value)...
LOOKUPVALUE('Table 1'[Employee Name], Table 1[Employee ID], 'Table 2'[Line Manager Employee ID])
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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.