Forum Discussion
Narender
Resolver I
Resolver IAdd 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...
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!!!
NarenderResolver I
Resolver IHiSwerd,
I am using this for other Purpose.
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.
Thanls,
Narender
Seward12533
Solution Sage
Solution SageWhat is the M code for the step that is inserting the A? If you don’t have the formula bar on you can turn it on under view ribbon. Or it may just be better if you paste your query? To do those choose advanced editor from the main ribbon.
Rather than using column from examples just add column with “A” in the formula window.
Rather than using column from examples just add column with “A” in the formula window.