Forum Discussion
Add column to a table
Dear
How are you? Please help me with the following:
I need to add to the following table 1 a column which is the union between the letter "S" and Column C as seen below:
| Table 1 | ||
| A | B | C |
| 1 | 6 | 11 |
| 2 | 7 | 12 |
| 3 | 8 | 13 |
| 4 | 9 | 14 |
| 5 | 10 | 15 |
Table 2
| A | B | C | D |
| 1 | 6 | 11 | S11 |
| 2 | 7 | 12 | S12 |
| 3 | 8 | 13 | S13 |
| 4 | 9 | 14 | S14 |
| 5 | 10 | 15 | S15 |
Stay tuned
Best regards
csalinas23 you can add either using DAX or Power Query, screenshots you sharing are Power Query, add a custom column and use following expression:
"S" & [C]and with DAX, to add a calculated column, use following
D = "S" & Table[C]if you don't know anything about the custom column in Power Query or calculated column in DAX, you need to spend some time to learns basics of Power BI.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
6 Replies
csalinas23 not sure you question, but you can add a calculated column like this
D = "S" & Table[C]I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Where?
Here?
Or here?
Stay tuned
Best regards
csalinas23 you can add either using DAX or Power Query, screenshots you sharing are Power Query, add a custom column and use following expression:
"S" & [C]and with DAX, to add a calculated column, use following
D = "S" & Table[C]if you don't know anything about the custom column in Power Query or calculated column in DAX, you need to spend some time to learns basics of Power BI.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
csalinas23 , new column
d = "S" & [C]
amitchandak not sure how your solution is different than mine. You don't' have to reply or obligated to eply to everything if you don't have a different solution, just a suggestion.
