Forum Discussion
Convert to Numeric value from string. VALUE AND FORMAT FUNCTION NOT WORKING
Hi I wanted to know if there was a way to extract a number from a text value.
This is how the data is being cleaned in and I want to use this as integers, but it is reading it as a string. Any idea on how to clean this up within Power BI to use these values as integers?
You can replace Mbps with empty string in Query Editor and convert the result column into number.
See tutorial here: https://support.office.com/en-us/article/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721.
Enter Mbps in Value to Find field and leave Replace With blank
3 Replies
You can replace Mbps with empty string in Query Editor and convert the result column into number.
How exactly do I do that?
See tutorial here: https://support.office.com/en-us/article/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721.
Enter Mbps in Value to Find field and leave Replace With blank
