Adding a fixed value in a column

[Anonymous]

Is it possible to add "DK0010" in all rows in the column named CustomerNumber? 

[Anonymous · Accepted solution]

Column = CONCATENATE("DK0010",Customer[CustomerNumber])

[Anonymous]

@Anonymous 

Create a New column

CustomerNumber =  "DK0010"

[Washivale]

Hi @Anonymous ,

Images posted by you are not visible, however, if you want to add a static value in a column.

Create a column and add function column = "DK0010"

this will create a new column with static value on all rows.

Regards,

Washivale

[Anonymous]

I hope the picture works now, but I need the values to be:

DK00105601153
DK00105604721 

etc 🙂

[Washivale · Accepted solution]

You can achieve this with EDIT query - Select Customer ID Column  - Transform -Format - ADD Prefix

[Anonymous · Accepted solution]

Column = CONCATENATE("DK0010",Customer[CustomerNumber])