Forum Discussion
Solved
Fix Error When Change Datatype
Hi All,
I want to retain my existing data frm getting error when change the datatype.
How I can resolve this?
Thanks.
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.
2 Replies
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
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.
