Forum Discussion

Administrator

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...

FreemanZ

Super User

3 years ago

hi Syndicate_Admin

try to identify the files with different data format and change their Locale.

check this

https://support.microsoft.com/en-us/office/set-a-locale-or-region-for-data-power-query-d42b9390-1fff-413f-8120-d7df0ced20b9

Forum Discussion

Different date formats in the same column

Related content

formatting time differences

Matrix visual - Formatting (rows format differently)

Conditional formatting for difference between bars?

Hide Measures Column (of different FORMAT) Column if contains no data

Different format setting for different row / column subtotals