Forum Discussion

Narender's avatar
Narender
Icon for Resolver I rankResolver I
8 years ago
Solved

Add a column in Power BI existing table

Hi All,   I have a table and I want to add a coulmn in that table Suppose Column_Flag in TableA.   Also I want to insert a charcter in each row of Column_Flag. Menas Cloumn_Flag=A  .   Wheneve...
Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    Hi Narender,

    If this new column to be added is not based on Any Conditions, i.e. If all the Entries in Column_Flag will be equal to 'A', just that the colmn should be automatically populated whenever new data comes, then you can achieve it using "Column From Examples" option in the Add Column of the Power Query Ribbon. Sames is show in the below pics

    Add Column from ExampleYou just directly specify a Character for it to be repeated in all rows

     

     

     

     Hope this solves your issue!!!

     

     

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

Hi Narender,

If this new column to be added is not based on Any Conditions, i.e. If all the Entries in Column_Flag will be equal to 'A', just that the colmn should be automatically populated whenever new data comes, then you can achieve it using "Column From Examples" option in the Add Column of the Power Query Ribbon. Sames is show in the below pics

Add Column from ExampleYou just directly specify a Character for it to be repeated in all rows

 

 

 

 Hope this solves your issue!!!

 

 

Narender's avatar
Narender
Icon for Resolver I rankResolver I
8 years ago

Hi Thejeshwar,

 

I did the same. But find a P value also.

 

So now I am trying to delete the new column and creating again.

 

I need to add this new column because i want to append this table with other table. For distinguish , I am using this new column as a flag. 

 

Thanks,

 

Narender