cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vincentmo Regular Visitor
Regular Visitor

How to a break a column into a new column?

split.png            .split.png

How do I seperate the numbers and the months letter into a new column? I tried the split method but none of the video from youtube are showing me how to break this in half.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
kentyler Established Member
Established Member

Re: How to a break a column into a new column?

Here is a good post on how to use find and replace in power query.

You could either replace the numbers with names, or the names with numbers.

https://www.howtoexcel.org/power-query/bulk-replace-values/
This is a good example of Slogan 1 from https://bislogans.com/3-shape-your-business-data-before-you-load-it-into-power-bi/  fixing problems in your data before you start working with it in Power BI can save you LOTS of problems. In this case you'd be using Power Query to do the fix.

View solution in original post

5 REPLIES 5
kentyler Established Member
Established Member

Re: How to a break a column into a new column?

So the text month names and the month numbers are mixed into the same column ? Can you show us a screen shot with some sample data ?

 

vincentmo Regular Visitor
Regular Visitor

Re: How to a break a column into a new column?

Correct the month names and month numbers are mixed into the same column. I'm trying to do some date filter but since month names and numbers are mixed, the data is not showing correctly. I posted another picture in my original post.

kentyler Established Member
Established Member

Re: How to a break a column into a new column?

Here is a good post on how to use find and replace in power query.

You could either replace the numbers with names, or the names with numbers.

https://www.howtoexcel.org/power-query/bulk-replace-values/
This is a good example of Slogan 1 from https://bislogans.com/3-shape-your-business-data-before-you-load-it-into-power-bi/  fixing problems in your data before you start working with it in Power BI can save you LOTS of problems. In this case you'd be using Power Query to do the fix.

View solution in original post

Super User
Super User

Re: How to a break a column into a new column?

One thought on this, Pivot your column and then choose all of the columns with the numbers and Unpivot those. Then choose all of the columns with text and Unpivot those.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

vincentmo Regular Visitor
Regular Visitor

Re: How to a break a column into a new column?

Thank you so much 🙂

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)