Forum Discussion
Helper IIHow to manually enter data into a new column
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.
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
2 Replies
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:
v-lili6-msftCommunity Support
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
