Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to add "DK0010" in all rows in the column named CustomerNumber?
Solved! Go to Solution.
Column = CONCATENATE("DK0010",Customer[CustomerNumber])
You can achieve this with EDIT query - Select Customer ID Column - Transform -Format - ADD Prefix
@Anonymous
Create a New column
CustomerNumber = "DK0010"
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
DK00105604721
etc 🙂
You can achieve this with EDIT query - Select Customer ID Column - Transform -Format - ADD Prefix
Column = CONCATENATE("DK0010",Customer[CustomerNumber])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |