Forum Discussion
Formatting date with inconsistent input data in same column
Hi all, I'm having trouble formatting a column of date data which has two date formats from the raw data. The input data has a mixture of d/m/yyyy and dd/mm/yyyy For example there is 2/8/2...
Hi mussaenda,
Unfortunately I do not share that luxury... Funny how it even teases me with the two US options. Also, I don't have admin privileges to change my OS system settings from US to UK.
Either way it wouldn't change the formatting issue but I would prefer dd/mm/yy
Hi Anonymous ,
You can try to change column type with 'using locale' option, it allow you to setting specific data type region to help power bi analysis records:
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}},"en-gb")
Local date formats in Power BI
Regards,
Xiaoxin Sheng