Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
racheljeska
Frequent Visitor

New Column

Hi all!

 

How do I create a formula to go from Column Example

Example
0934US923 Yellow Sun 
03duiw839 Purple Flower
3648idahd Green Frog
 

To Column Example 1

Example 1
0934US923 
03duiw839 
3648idahd 
 

 

I only want to keep the first 9 numbers/letters

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @racheljeska ,

 

Before:

tackytechtom_0-1718135381109.png

 

 

After:

tackytechtom_1-1718135395424.png

 

 

Below the steps that I used:

tackytechtom_2-1718135438769.png

 

tackytechtom_3-1718135470122.png

 

Let me know, if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

1 REPLY 1
tackytechtom
Super User
Super User

Hi @racheljeska ,

 

Before:

tackytechtom_0-1718135381109.png

 

 

After:

tackytechtom_1-1718135395424.png

 

 

Below the steps that I used:

tackytechtom_2-1718135438769.png

 

tackytechtom_3-1718135470122.png

 

Let me know, if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors