How to 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.

Power BI VLOOKUP example

Note: You can find the complete documentation for the LOOKUPVALUE function in DAX here.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Count Number of Occurrences in Power BI
How to Use “If Contains” in Power BI
How to Write an IF Statement with Multiple Conditions in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *