Forum Discussion
error date column
Hello PBI Community, Anyone please help me with this error in date column. Also i tried splitting the column with delimiter and had errors. Can anyone help me with either of these errors. I h...
Hi Anonymous
Remove your current Change Type step or convert the Date column to Text type first. Then right click on the Date column and select Change Type > Using Locale... In the Change Type window, select Date for Data Type, English (United Kingdom) or other locales which has the same date format as your original Date column input. This should change the type into Date correctly.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Anonymous
Your dates columns are not in Date Type, please change the type to date before this step.
Can you please elaborate further, I have changed from the data type to date.