Forum Discussion

sanchit's avatar
sanchit
Frequent Visitor
10 years ago
Solved

How to change the date format?

Hi, For Data: I have imported a .CSV file. I have two questions? My Date is in format 1/3/2016 7:56:00 AM (DD/MM/YYYY hh:mm:ss), but PowerBI is reading the Date as MM/DD/YYYY hh:mm:ss.         ...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    sanchit This is controlled by the Locale Setting!

     

    MM/DD/YYYY is the US format (and maybe some other countires not sure???)

     

    But your csv file likely came form a place where they use DD/MM/YYYY

     

    To have PBI recognize those as dates Go to File => Options and settings =>  Options => Locale => change to your country/region

     

hellovaras's avatar
hellovaras
Regular Visitor
8 years ago

Hello,

 

Tried the "Change Type" using "Locale" but I get errors. It seems all the errors happen for the "01", January. Please see below. How to fix this issue?

 

Error message:

 

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
    25/01/2005

amk27's avatar
amk27
New Member
3 years ago

You can also alternatively try this as a new column, adjust the sequence of first and second expression depending upon the date format that you have and concat them in the new column.


List.First(List.RemoveFirstN(Splitter.SplitTextByDelimiter("/")([Date]),1)) -> Evaluates second number in the Date value

List.First(Splitter.SplitTextByDelimiter("/")([Date])) -> Evaluates first number in the date value

List.Last(Splitter.SplitTextByDelimiter("/")([Date])) -> Evaluates year in the date value