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?
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?
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.