Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
mussaenda's avatar
mussaenda
Community Champion
6 years ago

Hi Anonymous ,

 

I disagree.

Mine has this one.

 

I am using English UK as default language for the report.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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