Forum Discussion
Convert to Number error
Hi Anonymous ,
If you don't want to automatically detect the data type, you can turn off the related functions through the following article.
Data types in Power Query | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I may have reproduced your problem. This is because your Vendor column contains a value of ‘10357a’, which is not a number.
Please check your Vendor column, you can find the problematic row by filtering as follows.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen, That is why I converted the column to Text, but it is still trying to convert it to a number. I'm not sure what I have done wrong & why it won't accept that
Hi Anonymous ,
If you don't want to automatically detect the data type, you can turn off the related functions through the following article.
Data types in Power Query | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I have done this as it was the easiest way to create the result I want, but not sure why it wouldn't accept my change data type