Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding a fixed value in a column

Is it possible to add "DK0010" in all rows in the column named CustomerNumber?   
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    Column = CONCATENATE("DK0010",Customer[CustomerNumber])
  • Washivale's avatar
    Washivale
    6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

DK00105601153
DK00105604721 

etc :-)

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Column = CONCATENATE("DK0010",Customer[CustomerNumber])