VLOOKUP Equivalent in Power BI

[Anonymous]

Hello,

I have 2 tables, Actual, New Hire List and Driver List. 

Table 1: (Actual - Has Employee ID of both New Hires and Drivers)

Date Emp ID Order Number 

xxxx   1             1234

xxxx   2             1235

xxxx   3             1236

xxxx   4             1236

Table 2: (New Hires)

Date    Emp ID  Job Title

xxxx      1           New Hire

xxxx       2         Driver

xxxx       3         New Hire

xxxx       4        Driver

Thus, I want a column in Table 1 as follows: 

Date Emp ID Order Number   Job Title

xxxx   1             1234                New Hire

xxxx   2             1235                Driver

xxxx   3             1236                New Hire

xxxx   4             1236                Driver

I want to match the EMP Id's from Table 1 to the 2nd table and get their job title in Table 1. Is this possible in Power BI?

Thank you.

[Anonymous · Accepted solution]

@Anonymous Yes, it's called "LOOKUPVALUE()" --

If you are going to put it on the 'Actual' table, the formula you want is:

 Job Title = LOOKUPVALUE('New Hires'[Job Title], 'New Hires'[Emp ID], 'Actual'[Emp ID])

Hope this helps 🙂