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.
Hello
Does anybody know if punctuation can be removed from numbers in a column (the data type is set as 'Any' as there are also lots of words in the column)? I currently have a relationship set up with a file containing the part numbers that are in this column that are without a '.' so I am looking to remove the '.' on my source file so that the 2 files recognise the same data (like Find/Replace in Excel)
Many thanks
Solved! Go to Solution.
In Power Query, right-click the column and choose "Replace Values".
Hi @Anthea,
In Query Editor mode, right click the column which contains punctuation ".", choose "Replace values".
Best regards,
Yuliana Gu
Hi @Anthea,
In Query Editor mode, right click the column which contains punctuation ".", choose "Replace values".
Best regards,
Yuliana Gu
Yes, in Power Query you can do a replace of anything with blank.
Thanks, how do I do this?
In Power Query, right-click the column and choose "Replace Values".
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |