Forum Discussion
Adding custom column causes "blank values error"
Finally I found the problem myself: the column that was mentioned in the error message was also a custom added column and I had added it with "Int64.type". For whatever reason this didn't cause any issues until I changed the type of the other column. Removing the "Int64.Type" from the first column, fixed the issue - although I don't have the slightest idea why because these two columns don't have anything to do with each other.
Ok, I have to correct myself: Adding a column doesn't seem to be the source of the problem. If I manually filter out all the Text values in the column and then use
= Table.TransformColumnTypes(#"Filtered Rows",{{"Column", type number}})to create a numeric column it looks fine in the query editor but as soon as I apply the changes the error still appears.
Finally I found the problem myself: the column that was mentioned in the error message was also a custom added column and I had added it with "Int64.type". For whatever reason this didn't cause any issues until I changed the type of the other column. Removing the "Int64.Type" from the first column, fixed the issue - although I don't have the slightest idea why because these two columns don't have anything to do with each other.