Using Power Query, I'm trying to change the type of a column that has values such as this into decimal.
But I get the following error:
DataFormat.Error: We couldn't convert to Number.
This is when in my Advanced Options, the decimal separator seems to be . which is the one used in the column.
1 Answer
Try adding an index, then add a custom column with formula
=Number.From([Amount])Filter that for errors and that will find you your problem data row
2
