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

5 Replies

  • Washivale's avatar
    Washivale
    Resolver V
    6 years ago

    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'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])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    Create a New column

    CustomerNumber =  "DK0010"