Forum Discussion
DataFormat Error: We Couldn't convert to Number
Hi,
I am getting this error when I try to sort a True/False Column in Descending order
[DataFormat.Error] We couldn't convert to Number.
Details:
O
When I filter the field, all I see is True/False on the field.
Thanks
-w
Hi Anonymous ,
You can refer the following link to update the formula of custom column as below:
=try Value.Is(Number.From(Text.Range([myfield],3,1)),type number) otherwise falseBest Regards
6 Replies
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Thanks Amichandak,
I found this good article on DataFormat Error here.
I started following the steps
I see what is causing a problem where a string has an O (not a zero(0)) in the 4th position
What I do not understand:
I think my Power Query Inspection formula should handle the string and simply return a true or false -- not an error.
Formula:
Value.Is(Number.From(Text.Range([myfield],3,1)),type number))
I am only getting the 1 error, so the formula is working for all other instances where sometimes the 4th character is a number, sometimes not.
Thanks-w
Hi Anonymous ,
You can refer the following link to update the formula of custom column as below:
=try Value.Is(Number.From(Text.Range([myfield],3,1)),type number) otherwise falseBest Regards
Can you provide some data that does not show an error when the 4th character is not a number (so a text value that does not error)?
I would expect the Number.From to throw an error for any text value that won't convert to number.
There are ways to deal with this but maybe you can provide the example first.
