Add Column - Map ID to Value

[quinla01]

Hi All, 

Hoping this is fairly simple. I have single table as shown below (real table has 1000's of rows)

I'm not interested in "Manager ID". I want manager name as per below. 

Any suggestions? The logic is something along the lines of

• Get manager ID from column 3
• If it's null do nothing. 
• if it's not null then find ID in column 1 and retrun employee

Thanks

[v-lili6-msft · Accepted solution]

hi, @quinla01 

You could use LOOKUPVALUE Function to create a calculate column as below:

Manager = IF(ISBLANK('Table'[Manager ID])=FALSE(),LOOKUPVALUE('Table'[Employee],'Table'[ID],'Table'[Manager ID]))

Result:

Best Regards,

Lin

[quinla01]

That worked a charm. Many Thanks. 

Out of interest, do you know how this would be done from the query editor rather than in report view? 

Thanks