Table of Contents
VLOOKUP is a powerful function in Power BI that allows users to search for a specific value in a table or range of data and retrieve information from another column in the same row. This function is useful for data analysis and reporting, as it can quickly and accurately match data from different sources. To use VLOOKUP in Power BI, users must first identify the columns they want to match and the data they want to retrieve. They can then create a new column or add the retrieved data to an existing one using the VLOOKUP function. This feature is particularly helpful for organizing and consolidating large datasets, as it eliminates the need for manual data matching. Overall, VLOOKUP in Power BI is an essential tool for data manipulation and analysis, making it a valuable asset for businesses and individuals alike.
Use VLOOKUP in Power BI (With Example)
You can use the VLOOKUP function in Excel to look up a specific value from one table in another table and return a corresponding value in another table.
To replicate this functionality in Power BI, you can use the LOOKUPVALUE function with the following syntax:
Points = LOOKUPVALUE('data2'[Points], 'data2'[Team], 'data1'[Team])
This particular example create a new column named points that looks up the value from the Team column in data1 within the Team column in data2 and returns the corresponding value from the Points column in data2.
The following example shows how to use this syntax in practice.
Example: How to Use VLOOKUP in Power BI
Suppose we have the following table named data1 that contains information about the Team and Position for various basketball players:
And suppose we have another table named data2 that contains information about the Team and Points for the same basketball players:
Suppose that we would like to look up the values from the Team column in data1 within the Team column in data2 and returns the corresponding value from the Points column in data2.
To do so, make sure the data1 table is active, then click the Table tools tab along the top ribbon, then click the New column icon.
Then type in the following formula into the formula bar:
Points = LOOKUPVALUE('data2'[Points], 'data2'[Team], 'data1'[Team])
This will create a new column named Points that contains the points values from the data2 table that correspond to each team in the data1 table.
Note: You can find the complete documentation for the LOOKUPVALUE function in DAX .
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: