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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CloudMonkey
Post Prodigy
Post Prodigy

Related column look up in query editor

Hi,

 

I know in the table view I can use the RELATED function to effectively do a vlookup into another table. But I need this column to be available in the query editor so I think I need to create the column in the query editor? Please can you tell me how to do this?

 

Thanks,

 

CM

6 REPLIES 6
sajju113
New Member

Thank you! @CheenuSing 

v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @CloudMonkey,

 

Have you tried the solution provided by @CheenuSing above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards

Hi @CheenuSingCheenuSing - thank you that works but my 2 source tables are very large so I have to then delete a lot of columns after the merge. Is there a way to define exactly which columns I want to merge when creating the merge query?

 

Thanks,

 

CM

Anonymous
Not applicable

When merging you should only get a single new column in the new table.

 

In that column, in the upper right corner click the expand icon and select which columns you want to include from your merge.

CheenuSing
Community Champion
Community Champion

Hi @CloudMonkey

 

In the edit query mode, you can try the Merged Queries to bring in data from other table. Similar to look up value using related.

 

Try it out if you still have issues you can post back here.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Anonymous
Not applicable

@CheenuSing CheenuSing - This suggestion is simple and effective. Thank you!


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors