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

Add Column - Map ID to Value

Hi All, 

 

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

 

Q1.JPG

 

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

 

Q2.JPG

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Add Column - Map ID to Value

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:

6.JPG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Add Column - Map ID to Value

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:

6.JPG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
quinla01 Frequent Visitor
Frequent Visitor

Re: Add Column - Map ID to Value

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

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 56 members 1,072 guests
Please welcome our newest community members: