Forum Discussion
Error when changing text to number
replace .0 with blank for all columns then try to convert into nbumbers .
you need to select a column then you can find replace under the transform section.
this should work .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Thank you for lookign at this 🙂
Sure, I uploaded a file here. But its really just a powerBI file with the dataset linked. I have uninstalled and redid everything several times now but I have the same issue.
Looking at your file I see that it is not adding the .0 decimal to the numbers as it is in my file. Im pretty sure that is the problem here.
replace .0 with blank for all columns then try to convert into nbumbers .
you need to select a column then you can find replace under the transform section.
this should work .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Thank you, that was a easy way to solve it!