What is VLOOKUP in Power BI?

If you're transitioning from Excel to Power BI, one of your first questions is probably, "Where is the VLOOKUP function?" You're not alone. While Power BI doesn't have a function named VLOOKUP, it offers several more powerful and efficient ways to accomplish the same task. This tutorial will walk you through the Power BI methods for looking up data and joining tables, moving from the most common approach to more specific formula-based solutions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

So, Why Doesn't Power BI Have a VLOOKUP Function?

The biggest reason Power BI doesn't have a direct VLOOKUP equivalent comes down to its core design. Excel is a spreadsheet - a grid of individual cells. Functions like VLOOKUP are designed to scan a range of cells to find a value and return a corresponding value from another cell in that range.

Power BI, on the other hand, is a relational database tool. It's built to work with entire tables of data and understand how they're related to one another. Instead of thinking in terms of grabbing single cell values, Power BI encourages you to think in terms of connecting whole tables. Once tables are connected, you can pull in columns from any related table as if they all lived in one giant table, completely eliminating the need for a function like VLOOKUP in most reporting scenarios.

This "relational" approach is far more efficient and scalable. A single relationship can do the work of thousands of individual VLOOKUP formulas, with better performance and less room for error.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Create Relationships (The True "Power BI Way")

The cleanest, most efficient, and recommended way to "look up" data in Power BI is by creating relationships between your tables. This is the foundational concept that unlocks the "BI" in Power BI.

What are Relationships?

A relationship is a link between two tables that share a common column, often called a "key." For example, you might have a Sales table with a ProductID column and a Products table that also has a ProductID column, along with ProductName and ProductPrice. By creating a relationship on the ProductID column, you're telling Power BI how these two tables connect.

Once this connection is made, you can build a chart in your report that uses SalesAmount (from the Sales table) and ProductName (from the Products table), and Power BI automatically understands how to match them up correctly.

How to Create a Relationship in Power BI

Setting up relationships is surprisingly simple. Let’s use our Sales and Products example.

1. Load Your Data: First, ensure both tables (e.g., 'Sales Transactions' and 'Product Details') are loaded into your Power BI Desktop file.
2. Go to Model View: On the left-hand side of the Power BI window, click on the "Model" icon. This view shows you all the tables in your data model as boxes.
3. Identify the Common Column: Find the column that exists in both tables. In our case, it's ProductID.
4. Click and Drag: Click on the ProductID column in your 'Sales Transactions' table, hold down the mouse button, and drag your cursor over to the ProductID column in the 'Product Details' table.
5. Release and Confirm: Release the mouse button. Power BI will draw a line between the two tables, indicating a relationship has been formed. You can double-click this line to inspect its properties, like cardinality (e.g., many-to-one) and cross-filter direction, though Power BI usually auto-detects these correctly.

That's it! Now, when you go back to the "Report" view, you can create a table or a chart and seamlessly use columns from both tables together.

Method 2: Merge Queries in Power Query (The Data Prep Method)

Sometimes, you might want to physically combine the tables during the data-loading process. This is useful if you want to create a new, flattened table that includes columns from multiple sources. The best place to do this is in the Power Query Editor using the "Merge Queries" feature.

When to Use Merge Queries

Merging is ideal when you need to permanently add columns from one table to another as a data preparation step. It's like doing a VLOOKUP once to bring in the data you need and then saving that result. This is different from a relationship, which keeps the tables separate but knows how they're related for analysis.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Merge Two Tables in Power Query

Let's imagine we want to add the Category from a 'Product Categories' table to our main 'Products' table.

1. Open Power Query Editor: In Power BI Desktop, go to the "Home" ribbon and click on "Transform data." This will open the Power Query Editor.
2. Select Your Main Table: In the Queries pane on the left, select the table you want to add columns to. In this case, our 'Products' table.
3. Start the Merge: On the "Home" ribbon, click the "Merge Queries" button.
4. Configure the Merge: A new window will appear.
5. Expand the New Column: After you click "OK," a new column will be added to your 'Products' table. This column will have a name like "Product Categories" and its values will say "Table." Don't worry, this is normal!
6. Apply Changes: Click "OK," and you’ll see the new category names added to your 'Products' table. Click "Close & Apply" in the Power Query Editor to load these changes into your data model.

Method 3: Using DAX Functions (The Formula Approach)

While relationships and merging are the preferred methods, there are times when you need to create a calculated column using a formula, just like in Excel. DAX (Data Analysis Expressions) is Power BI's formula language, and it has functions that are far more powerful than VLOOKUP.

Using the RELATED Function

The RELATED function is the simplest and most efficient DAX lookup function. It works only when a relationship already exists between two tables.

It "travels" along an existing relationship to fetch a value from the "one" side of a many-to-one relationship. For instance, you can use it in your 'Sales' table to pull the ProductName from the 'Products' table.

How it Works

1. Navigate to the "Data" view in Power BI Desktop and select your 'Sales' table.
2. Go to the "Table tools" ribbon and click "New column."
3. In the formula bar, type the following DAX formula:

Product Name = RELATED(Products[ProductName])

Press Enter. Power BI will create a new column called "Product Name" in your Sales table and populate it with the correct product name for each transaction by following the relationship you created earlier.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Using the LOOKUPVALUE Function

Now, LOOKUPVALUE is the function that looks and feels the most like Excel's VLOOKUP. It can retrieve a value from a column even if no active relationship exists between the tables. However, it's less performant than RELATED and should be used more strategically.

The syntax is: LOOKUPVALUE(<result_column>, <search_column>, <search_value>)

This translates to:

• result_column: The column containing the value you want to return (like the second column in a VLOOKUP range).
• search_column: The column you want to search through (the first column in a VLOOKUP range).
• search_value: The value you're looking for (the lookup value).

How it Works

Let's create the same "Product Name" column in the Sales table using LOOKUPVALUE. You’d create a new column and use this formula:

Product Name via LOOKUP = LOOKUPVALUE( Products[ProductName], Products[ProductID], Sales[ProductID] )

Here, for every row in the 'Sales' table, this formula looks at the Sales[ProductID], finds that same ID in the Products[ProductID] column, and returns the corresponding Products[ProductName].

Which Method Should You Use?

Here’s a quick guide to help you choose:

• Create Relationships: Use this 95% of the time. It is the best practice for building a clean, scalable, and high-performing data model for reporting and analysis.
• Merge Queries: Use this when you are performing data cleanup and preparation steps and need to permanently bake new columns into a table before analysis begins.
• Use DAX (RELATED or LOOKUPVALUE): Use this when you need to create a specific calculated column for a special calculation and can't (or don't want to) modify the relationships or model structure. Always prefer RELATED over LOOKUPVALUE if a relationship exists.

Final Thoughts

Moving from Excel's VLOOKUP to Power BI's methods is a shift from cell-based thinking to model-based thinking. By embracing relationships as your primary tool, supported by Merge Queries for data prep and DAX functions for specific calculations, you unlock a far more powerful and sustainable way to analyze your data.

We know that learning all the rules for Power Query merges, DAX formulas, and data model relationships can feel complicated and disconnected from the simple questions you're trying to answer. We built Graphed because we wanted to skip the manual setup and get straight to the insights. Simply connect your sources like Google Analytics, Shopify, or Salesforce, and ask "Show me my sales by product category as a pie chart." We automatically handle all the difficult joins, relationships, and lookups in the background and instantly build the report for you.