cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cloud11
Post Patron
Post Patron

Power Query add a word infront of current data

Hi Experts

 

In Power Query, i have singke column which shows  Software Usedie.

Microsoft Excel,

Microsoft Access, etc.. which are fine. However, inputs in that column have been in putted as Excel less Microsoft at the start. How can I create a custom column which add Microsoft to the start if it does not exist.

1 ACCEPTED SOLUTION
Pragati11
Super User III
Super User III

Hi @Cloud11 ,

 

Add a new custom column in query editor as follows:

Pragati11_0-1610040025738.png

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

3 REPLIES 3
Pragati11
Super User III
Super User III

Hi @Cloud11 ,

 

Add a new custom column in query editor as follows:

Pragati11_0-1610040025738.png

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

parry2k
Super User III
Super User III

@Cloud11 replace [Item] with your column name.

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.





parry2k
Super User III
Super User III

@Cloud11  add a new column using the following M code

 

if Text.StartsWith(Text.Proper([Item]),"Microsoft") then [Item]  else "Microsoft " & [Item]





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.





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!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors