Error Convert Text to Number, one column contains text and number

[ariaqi]

Hi,

I have a column cotains text and number. It automatically convert it to Number. I changed the datatype to Text in power quert editor, but still got error: couldn't convert to Number. Do you know how I can fix this? Thanks so much.

[smpa01]

@ariaqi  IFERROR equivalent

add a custom column
try Number.From([column])/Text.From([column]) otherwise -999/"-999"

[bcdobbs · Accepted solution]

If you look in the lists of steps on the right hand side I'm guessing you now have two "Changed Type" steps.

You need to go back and click on the first one and change the type of the column at that point to text. It will ask if you want to overright the step. Click yes.

[ariaqi]

Thanks so much!! It fixed!