POWER BI [PI-300]: I have a column which contains text and numbers.

I want to change the data type to Decimal Number.

What would happen?

Question

I have a column which contains text and numbers.

I want to change the data type to Decimal Number.

What would happen?

da-bi · Accepted Answer

Any text data (non-numeric) will be replaced by the word 'Error'

I have a column which contains text and numbers. I want to change the data type to Decimal Number. What would happen?