cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CloudMonkey Member
Member

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

5 REPLIES 5
Highlighted
CheenuSing Super Contributor
Super Contributor

Re: Related column look up in query editor

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!
v-ljerr-msft Super Contributor
Super Contributor

Re: Related column look up in query editor

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

CloudMonkey Member
Member

Re: Related column look up in query editor

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

Re: Related column look up in query editor

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.

stimpy9000 Occasional Visitor
Occasional Visitor

Re: Related column look up in query editor

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


Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 273 members 2,662 guests
Please welcome our newest community members: