Forum Discussion
Issue in conversion of csv dates in PowerBI
v-jingzhang thanks for your response. I havent tried your solution but what worked was using the text to column feature and recreating a custom column for the date function.
Yes, I did. Pls see beloe the data points.
Actual data
Budget data
Forecast data
One more thing, I noticed that my model looks a bit different from the sample solution model. Could this be the reason.
Sample
My version
Really appreciate all your help and guidance, much appreciated!
Community SupportHi Anonymous
Currently your dates are not recognized with the correct Locale format. You need to go to Power Query Editor, remove the auto-generated "Changed Type" step from "Applied Steps" pane, then change data types of all columns manually. For these date columns, change them to date type with locale English (United Kingdom). This will make Power Query recognize the correct day and month values. After that, apply the queries to Power BI Desktop and try dragging a date column to a table visual to check whether the date values are correct. Ensuring date values are correct is the first step before everything.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
v-jingzhang thanks for your response. I havent tried your solution but what worked was using the text to column feature and recreating a custom column for the date function.