cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mayur23 Frequent Visitor
Frequent Visitor

VLOOKUP Equivalent in Power BI

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.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SirGalatsi Member
Member

Re: VLOOKUP Equivalent in Power BI

@mayur23 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 Smiley Happy

1 REPLY 1
SirGalatsi Member
Member

Re: VLOOKUP Equivalent in Power BI

@mayur23 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 Smiley Happy