Add data column

[Anonymous]

Hi,

I have a data table that has been copied into Power BI.  I would like to add a data column (not from a forumula) that I just type the values in.  But I don't see anyway to do that.

When I click enter data it always wants to create a new table which is NOT what I want to do.  I just want to add a new column that I can type whatever data I want in.

Thanks,

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

As you said, it is not supported to add a column via typing any value you want.

To work around this requirement, you could

1. insert an index column to source table in Query Editor mode.
2. create a new table by clicking enter data, one column should list values like 1,2,3, etc, another column should display those values you want to add.
3. create a one to one relationship between these two tables based on index column (1,2,3,etc).
4. In source table, create a calculated column using formula like Column=Related(NewTable[Column2])

Alternativele, repeate above step1 and step2, then, create a new column in source table using formula like: Column=LOOKUPVALUE(NewTable[Column2],NewTable[Column1],SourceTable[Index])

Best regards,
Yuliana Gu

[Anonymous]

Wow that is a HUGE flaw.  I hope they fix this soon.  Something so easy to do in excel should be possible here as well.

Thanks for the answer.