Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
.
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
Solved! 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.
Help when you know. Ask when you don't!
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 ?
Help when you know. Ask when you don't!
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.
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.
Help when you know. Ask when you don't!
Thank you so much 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
97 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |