Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sag_tyd
Frequent Visitor

Look up data and append to same row within table

Hello Experts,

 

I have an interesting use case where I have data contained in a table, but the data does not contain a certain level of information that I need for visualization purposes. I need to somehow search through the table based on one column and append the results of a different row to the original row. Bit hard to explain so here's an example:

 

I have the following data set:

IDNameFriend ID
1Alex3
2Joe3
3Bob1
4Phil2
5Marknull

 

I want to add a "Friend Name" column as such:

IDNameFriend IDFRIEND NAME
1Alex3Bob
2Joe3Bob
3Bob1Alex
4Phil2Joe
5Marknullnull

 

However, I cannot figure out how to do this. The iterative process of looking at each row individually and then searching through the table is tripping me up. 

 

Thanks for your help!

1 ACCEPTED SOLUTION
sevenhills
Super User
Super User

If you want the column in DAX, you can do as below: Say, your table is 

Parent_Child_Lookup

 

Friend Name = LOOKUPVALUE(Parent_Child_Lookup[Name], Parent_Child_Lookup[ID], Parent_Child_Lookup[Friend ID], BLANK())

 

sevenhills_0-1686163715500.png

 

View solution in original post

3 REPLIES 3
sevenhills
Super User
Super User

If you want the column in DAX, you can do as below: Say, your table is 

Parent_Child_Lookup

 

Friend Name = LOOKUPVALUE(Parent_Child_Lookup[Name], Parent_Child_Lookup[ID], Parent_Child_Lookup[Friend ID], BLANK())

 

sevenhills_0-1686163715500.png

 

That worked perfectly! Thank you very much! I knew it was something simple using the LOOKUPVALUE function, I just couldn't figure it out. Much appreciated. 

Glad to hear that it worked ! Thanks

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.