Help with Column Data Type Conversion

Thanks for the reply from saud968, please allow me to provide another insight:

Hi, rcgx13 
Thanks for reaching out to the Microsoft fabric community forum.

Could you please let us know if h saud968‘s response resolved your issue? If it did, kindly accept it as the solution.

As saud968  mentioned, data containing characters or spaces cannot be converted to numeric types.

You can use the Text.Replace() function in Power Query to replace spaces with empty strings. Alternatively, the Text.Trim() function is also a good choice. For further details, please refer to:

Text.Trim - PowerQuery M | Microsoft Learn
Text.Replace - PowerQuery M | Microsoft Learn
 

You may need to note that if you change the data type, you need to click "Replace Current"; otherwise, the error will persist.

 For more information on changing data types, please refer to:

Data types in Power BI Desktop - Power BI | Microsoft Learn

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.