Forum Discussion
Adding a column to an existing table
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your answer / solution. It worked perfectly.
- amitchandak
Super User
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.
