Forum Discussion
Adding a fixed value in a column
Is it possible to add "DK0010" in all rows in the column named CustomerNumber?
Column = CONCATENATE("DK0010",Customer[CustomerNumber])You can achieve this with EDIT query - Select Customer ID Column - Transform -Format - ADD Prefix
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
I hope the picture works now, but I need the values to be:
DK00105601153
DK00105604721etc :-)
Column = CONCATENATE("DK0010",Customer[CustomerNumber])You can achieve this with EDIT query - Select Customer ID Column - Transform -Format - ADD Prefix