cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
csalinas23
Helper I
Helper I

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
ABC
1611
2712
3813
4914
51015

Table 2

ABCD
1611S11
2712S12
3813S13
4914S14
51015S15

Stay tuned

Best regards

1 ACCEPTED SOLUTION

@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.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

6 REPLIES 6
amitchandak
Super User IV
Super User IV

@csalinas23 , new column

d = "S" & [C]



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Where?

Here?

csalinas23_0-1597245599226.png

Or here?

csalinas23_1-1597245638166.png

Stay tuned

Best regards

Hi, @csalinas23 

It seems that your problem has been solved.
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

@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.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.