Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RonaldS
Regular Visitor

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

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!

1 ACCEPTED SOLUTION
RonaldS
Regular Visitor

Solved, found the answer...

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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

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
New Member

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

RonaldS
Regular Visitor

Solved, found the answer...

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

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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.