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.
Go to Solution.
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
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 ?
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.
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.
Proud to be a Datanaut!
Thank you so much 🙂
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!