Forum Discussion

RenaG's avatar
RenaG
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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.