How to manually enter data into a new column

[kwpbi]

Hi,

I have a table with 2 columns that come from a different table using the "ADDCOLUMNS" function.

I now want to add a third column and manually enter some whole numbers into it. Is this possible?

Thank you.

[v-lili6-msft · Accepted solution]

hi, @kwpbi 

You could to add the column in your 'ADDCOLUMNS' formula

ADDCOLUMNS(<table>, <name>, <expression>[, <name>, <expression>]…)

But couldn't enter it directly. 

and could also add the new column in the basic table then keep it to new table.

Best Regards,

Lin

[Anonymous]

@kwpbi Hey how big is your dataset? 

You can do the follows: 

Dataset is small - you can enter values manually (Even though it will try to find some patterns)

Or if there is a pattern this could be useful. Example, you have a first name and last name column, then you can start typing both names together to create a full name, PowerBI detects the pattern and creates a merge between the 2 columns to automatically get you the full name column.   

Or you could create another able by entering data to a new column: