Modeling: Add new column in table with same value for all rows

[RonaldS]

Hello,

New to PowerBI and doing a lot of training right now.

I hope an easy question:  how to add a new column in table with same value for all rows.

To add a column is known, but how to set a new single value for all rows with one command?

Thank you!

[Anonymous]

In the Query Editor, go to > Add Column > Custom Column >

In the custom column formula something like = "abc" will create a column of all "abc" values

[dd96]

I would like to know if this works with incremental refresh or not. 

lets assume that i am adding a custom column in my table and setting value = "abc" for example , all the cached rows will have a value 'abc' for a custom column but after every incremental refresh , will new rows have the same value ? 

would be great if you can help. 

Thank you 

[dfechter]

How do you read the solution? When I click on it it just takes me to the bottom of the page.

[RonaldS · Accepted solution]

Solved, found the answer...

[dfechter]

How do I read the solution? When I click the link it takes me to the bottom of the page.

[RonaldS]

Hello,

I found it here:

https://support.office.com/en-us/article/insert-a-custom-column-into-a-table-power-query-2dbb579a-91...

Add a custom column, give it a name and enter the value as formula like "ABC"

That's all...