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

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

RonaldS — Mon, 26 Mar 2018 09:09:13 GMT

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!

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

RonaldS — Mon, 26 Mar 2018 10:58:48 GMT

Solved, found the answer...

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

dfechter — Tue, 01 May 2018 20:24:34 GMT

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

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

dfechter — Tue, 01 May 2018 20:26:51 GMT

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

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

RonaldS — Tue, 01 May 2018 21:38:56 GMT

Hello,

I found it here:

https://support.office.com/en-us/article/insert-a-custom-column-into-a-table-power-query-2dbb579a-915b-4ebd-b622-8e7f3d1d61a6

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

That's all...

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

Anonymous — Wed, 08 Jan 2020 21:40:09 GMT

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

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

dd96 — Wed, 19 Oct 2022 18:41:12 GMT

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