Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Different 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...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Hello.

This is the case. I share image and PBI file.

In the source I only have 2 dates with months of November and December, only written both ways.

Imagine I'm connected to over 1,000 csv files, and it would be tedious to go find each of the csv files and change the shape from there.

When loaded into the model, it reads like this:

Here you can download the PBIX:

https://drive.google.com/file/d/14csUOFvoyZAmZVS0uWOAs6AaTtatqs_y/view?usp=sharing