Adding a column to an existing table

[RenaG]

Hi,

I have a PBIX that uses imported Excel spreadsheets as it's source of data. Once the tables are imported I go through a couple Merge processes on each table to bring in data from a couple other tables. This modified table is the Appended to a master copy.  Last year the input table looked like this:

Col A | Col B | Col C | Col D

Folowing Col D are the new columns added from the Merge steps. The table is saved in a Historical folder.

This year the table looks like this:

Col A | Col B | Col C | Col D | Col E

How do I add Col E to the Master so that I can bring in the new table?

I hope this makes sense.

TIA!

Rena

[Anonymous · Accepted solution]

Hi @RenaG ,

In Power BI Desktop, you can add a new custom column of data to your model by using Power Query Editor.  

To create a custom column, follow these steps:

• Launch Power BI Desktop and load some data.
• From the Home tab on the ribbon, select Transform data, and then select Transform data from the menu.
• From the Add Column tab on the ribbon, select Custom Column.

Add a custom column in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RenaG]

Thank you very much for your answer / solution.  It worked perfectly.

[amitchandak]

@RenaG , Ensure that Column E is included in your source data. In Power BI, new columns like Col E are typically detected automatically. Just verify that it's incorporated during the merge steps to update your Master table accordingly.