Forum Discussion
Missing dates when importing data from CSV file
Hello everyone, I am importing environmental data from a CSV file. The column containing the Date is in text format in the CSV file. I noticed that Power BI "confuses" month and day when formatin...
Hi Anonymous ,
Please have a try.
Add a column below:
Text.Combine({"20" & Text.End([Date], 2), Text.BetweenDelimiters([Date], "/", "/"), Text.End(Text.Start([Date], 4), 2)}, "/")
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.