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
willboyes
Frequent Visitor

Replicating vlookup in same table

Hi - apologies if I'm missing something really obvious here, but I'm struggling to replicate a Vlookup in Power BI.

 

I have a table with 3 columns, the first is a consecutive ID value for each row, the second is a text string, and the third is another set of IDs which reference the first column.  I need to add another column which shows the text string from the second column, where the IDs in the first and third columns match. This is a simple Vlookup in Excel...

 

This table uses data from a Sharepoint Task app. The third column uses IDs to reference task hierarchy within a list, e.g. a task begins with one entry and then multiple sub-tasks, each referencing the first task. The data from Sharepoint only provides IDs, whereas I need to use the text strings (task names) in my report.

 

Any help would be much appreciated! Thanks

2 ACCEPTED SOLUTIONS
Zubair_Muhammad
Community Champion
Community Champion

@willboyes

 

Try this Column

 

Column =
LOOKUPVALUE ( [Text String], [ID], [ID 2] )

lkup.png


Regards
Zubair

Please try my custom visuals

View solution in original post

@willboyes

 

With Power Query, you can do a self merge of the Table

 

lkup1.png

 


Regards
Zubair

Please try my custom visuals

View solution in original post

6 REPLIES 6
Zubair_Muhammad
Community Champion
Community Champion

@willboyes

 

Try this Column

 

Column =
LOOKUPVALUE ( [Text String], [ID], [ID 2] )

lkup.png


Regards
Zubair

Please try my custom visuals

Thanks very much - that's working now, not sure what I was doing wrong before!

If I wanted to replicate that approach in the query editor, how could I go about it?  

@willboyes

 

With Power Query, you can do a self merge of the Table

 

lkup1.png

 


Regards
Zubair

Please try my custom visuals

Hello,

 

I have a similar situation within a table that has a lot of columns and data also coming from other tables in a pretty complex model.

 

When I add that Merge step, followed by an Expand step, it causes my refresh to get hung and my report will no longer update.

 

I tried creating a simplified copy of the table to Merge and Expand from, but I am still running into the same issue.  

 

Any idea/suggestion?

Brilliant - worked first time!

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.