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!

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

RonaldS
Regular Visitor
8 years ago
Solved, found the answer...
- dfechter
  New Member
  8 years ago
  How do I read the solution? When I click the link it takes me to the bottom of the page.
  - RonaldS
    Regular Visitor
    8 years ago
    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...
Anonymous
Not applicable
6 years ago
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
  Frequent Visitor
  3 years ago
  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
8 years ago
How do you read the solution? When I click on it it just takes me to the bottom of the page.