How to do VLOOKUP in Power BI
Searching how to do VLOOKUP in Power BI? In this post I’ll show you how to use the Merge Queries function from Power BI to achieve this!
Free Power BI Template Download
Download now for free our Power BI template used in the video below:
Merging Queries in Power BI
Watch this video and learn how to do VLOOKUP in Power BI using the Merge Queries functionality:
How does the 'Merge Queries' work:
The Merge tables functionality from Power BI allows you to select common columns between 2 or more different tables, creating one single “Merged” table based on the selected column.
Easier than Excel's VLOOKUP!
Power BI’s Merge Queries is fairly easy to use, and with just a few clicks in the tool, allows you to extract multiple columns from multiple queries to one single query.
The Merge Queries in more details
You can find here more details on Microsoft’s webpage on the Merge Queries from Power Query which is available in Power BI.
Hi, I’m Vini!
I’m an Engineer and Data Analyst, and I moved to Germany in 2018 to work for one of the biggest logistics companies in the world. Hacks for Data Analysis is the place where I consolidate and share my knowledge, feel free to reach out to me. Cheers!