Forum Discussion
Number Error help please
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?
- amitchandak
Anonymous , in edit query mode create a new column that will show to data type of each row, see that can help to find the datatype issue