Forum Discussion
Number Error help please
I am hoping someone has an idea, because I am stumped. I am receiving the typical: [DataFormat.Error] We couldn't convert to Number. However, the Number it is trying to convert is this: 10/24/2069...
amitchandak
Super User
Super UserAnonymous , Seem like one column has shifted position for a row. Change the data type to text and filter and check the value , which rows the value. and then resolve it. Do it in data transformation/edit query mode
I tried your suggestion. On two different columns they won't load the filter because they error out with "We couldn't convert to number."
do you know a way to search for that value in an entire table in edit query
- amitchandak
Anonymous , check for data type value.type in power query. Create a new column and check and filter the one with different data type
I am not sure I follow: do you mean create a new column for each current column, but change the data type to any in the newly created column?