Forum Discussion
Syndicate_Admin
Administrator
AdministratorDifferent date formats in the same column
The source source is folders with csv files. There are many! 1 CSV file per day, since 2020. It happens that some of those files have the date column written in these 2 ways: Some are written l...
amitchandak
Super User
Super UserSyndicate_Admin , for this we have to check and the format each row. Like check if there is
following functions can help
Power Query - Text.Contains: https://youtube.com/watch?v=Hs2q6qcrdgU&feature=share
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.