How to Duplicate a Column in Power BI

Duplicating a column in Power BI is a fundamental task, but it opens up a ton of possibilities for cleaning and shaping your data. It’s the perfect way to make changes, split data, or reformat values while keeping your original column intact as a safety net. This article will walk you through exactly how to duplicate columns using the Power Query Editor and explain some common scenarios where this skill comes in handy.

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

Why Would You Need to Duplicate a Column?

Before jumping into the "how," let's quickly cover the "why." Duplicating a column isn't just about making a backup, it's a strategic move in your data preparation process. Here are some of the most common reasons you'll find yourself needing a copy of a column:

• Preserving the Original Data: This is the most obvious reason. If you plan to make significant changes to a column - like splitting it, replacing values, or changing its data type - duplicating it first means you always have the original, untouched data to refer back to. No need to re-import your data if you make a mistake.
• Creating Conditional Logic: You might want to create a new column with categories based on the values in another. For example, using a "Sales" column to create a new "Deal Size" column with values like "Small," "Medium," or "Large." Duplicating the column first can be part of this workflow, especially in more complex transformations.
• Splitting a Column into Multiple Parts: A classic example is a "Full Name" column that you want to separate into "First Name" and "Last Name." You'd duplicate the "Full Name" column twice, then split each new column differently to extract the piece you need, all while keeping the original "Full Name" column.
• Changing Data Types for Different Uses: Sometimes you need a column in two different formats. For example, you might have a "Date" column that you want to keep as a proper Date data type for calculations. But you may also need a text version formatted as "Month-Year" (e.g., "Jan-2024") to use as a simple label in a chart. Duplicating lets you have both.
• Performing Different Aggregations: In more advanced models, you might want to visualize the same base data in different ways. A duplicated column can be configured for a different type of aggregation (e.g., count vs. sum) or formatting without affecting the original field.

Duplicating Columns: The Step-by-Step Guide in Power Query

The best place to duplicate, transform, and clean your data is in the Power Query Editor. This is Power BI's built-in tool designed specifically for getting your data ready before it gets loaded into your report model. Any changes made here are applied every time your data refreshes.

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

Step 1: Open the Power Query Editor

First things first, you need to launch the editor. From the main Power BI Desktop window:

1. Go to the Home tab on the top ribbon.
2. Click on the Transform data button. This will open the Power Query Editor in a new window, showing all the data tables in your project.

Choose the query (table) that contains the column you want to work with from the list on the left.

Step 2: Select the Column to Duplicate

This part is simple. Just scroll to the column you want to copy and click on its header to select it. The entire column will highlight to show it's active.

Step 3: Duplicate the Column

You have two main ways to do this, and both are incredibly easy. Pick whichever one you prefer.

Method A: Using the Ribbon Menu

This is the most straightforward method if you prefer using the on-screen buttons.

1. With your column selected, go to the Add Column tab in the Power Query ribbon.
2. In the "General" section (usually on the far left), click the Duplicate Column button.

That's it! Power BI will instantly create an exact copy of your selected column at the end of your table, usually with a name like [Original Name] - Copy.

Method B: The Quick Right-Click Method

Many people find this way faster as it doesn't require switching tabs. I tend to use this one out of habit.

1. Hover over the header of the column you want to duplicate.
2. Right-click on the column header.
3. A context menu will appear. Select Duplicate Column from the list.

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

Step 4: Rename Your New Column (Best Practice!)

Immediately after duplicating, Power BI gives your new column a default name. It's crucial to rename this to something meaningful so you (and your colleagues) know what it's for. Leaving a bunch of columns named "Column - Copy" will quickly become confusing.

To rename it:

• Double-click directly on the new column's header.
• Or, right-click on the new column's header and select "Rename."

Type in a clear, descriptive name and press Enter.

Step 5: Close & Apply Your Changes

Once you're done duplicating and renaming columns in the Power Query Editor, you need to save those changes and load them into your Power BI report.

On the Home tab of the Power Query Editor window, click the Close & Apply button in the top-left corner. The editor will close, and your updated data model, including the new columns, will be available in your report view.

Putting It Into Practice: A Real-World Example

Let's use the common scenario of splitting a "Full Name" column into separate "First Name" and "Last Name" columns.

1. Start with one column: "Full Name" (e.g., "Alex Johnson," "Maria Garcia").
2. Duplicate it... twice: Right-click the "Full Name" header and select "Duplicate Column." Repeat this step so you have two copies.
3. Rename your new columns: Rename the first copy to "First Name" and the second copy to "Last Name."
4. Split the "First Name" column: Right-click the "First Name" column header, go to Split Column > By Delimiter. A dialog will appear.
5. Power BI is usually smart enough to guess the delimiter (a space in this case). Under "Split at," select Left-most delimiter. This will create "Alex" in one column and "Johnson" in the next.
6. You're left with two columns, "First Name" which holds names such as Alex, and "Last Name" that holds the rest. Remove the "First Name" column and rename "Last Name."
7. Follow a similar procedure to split Last Names using the right-hand separator to obtain the last name.

Now you have three clear columns - the original "Full Name" plus separated "First Name" and "Last Name." You've cleaned your data without destroying the source information.

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

"Duplicate Column" vs "New Column" - What's the Difference?

As you get more familiar with Power BI, you'll hear about another way to create columns: using DAX in the report view. It's important to understand the difference.

• Duplicate Column (in Power Query with M): This action is part of the data transformation and loading process. The M language is working in the background to create a new, physical column in your data model. This is best for pre-processing and structuring your data. The new column is created before any analysis happens.
• Calculated Column (in Report View with DAX): This happens after the data is already loaded. You write a DAX formula (e.g., State Abbreviation = [State Name]) to create a new column. This new column is also physically stored in your model and is calculated row by row. DAX columns are best when the calculation depends on relationships with other tables or requires a context that isn't available back in the Power Query Editor.

For something as simple as making a copy to modify - like splitting names or changing text to uppercase - the Power Query Editor's "Duplicate Column" feature is almost always the right choice. It keeps your data cleaning steps organized and separate from your analysis formulas (DAX).

Final Thoughts

Duplicating a column in Power BI’s Power Query Editor is a simple yet powerful technique for cleaning and transforming your data without risk. Whether you use the right-click menu for speed or the step-by-step ribbon, it’s a fundamental data preparation skill that gives you the freedom to reshape your dataset while always preserving the original.

Learning tools like Power BI is an excellent investment, but we know the work of connecting data sources and building reports from scratch can still feel complex and slow. For that reason, we built Graphed to simplify this entire process. We connect directly to your marketing and sales platforms (like Google Analytics, Shopify, and Salesforce), allowing you to create real-time dashboards and get instant insights just by asking questions in plain English - no need to manage complex queries or manual transformations.