Fix Error When Change Datatype

[syaz]

Hi All,

I want to retain my existing data frm getting error when change the datatype.

How I can resolve this?

Thanks. 

[v-eachen-msft · Accepted solution]

Hi @syaz ，

You data is not all time type. You need to use split  to clean your data. Here is my test result.

Here is my test file for your reference. You could open advanced editor to see the operation.

[amitchandak]

@syaz , there are multiple datatypes in this field. You may have to split column first

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Then you can get the column with correct data type