Forum Discussion

WilmaB's avatar
WilmaB
New Member
9 years ago
Solved

Converting date formats

I received a .csv file and the date format in the file is:

 

2015-05-11-02.59.58.878520

 

When I import the data into Power BI, it imports the date as a string and all attempts at converting this string to a date format has failed.  I added a new column and used both these formulas

 =DATEVALUE("2015-01-26-02.59.33.625380") 

Measure = DATEVALUE(LEFT("2015-01-26 02.59.33.625380",10)) 

 

Please help?  I need all the decimals as I am doing a SLA analysis where I need to calculate the time lapsed between records.

 

Thanks so much in advance

 

  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Go to Query Editor, Split Column by delimiter as shown in the screenshot.

    Split by Delimiter

     

     

5 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Go to Query Editor, Split Column by delimiter as shown in the screenshot.

    Split by Delimiter

     

     

    • WilmaB's avatar
      WilmaB
      New Member
      9 years ago

      Thank you. I managed to convert the date but it was much easier to do in SQL and then import. The solution did work though, thanks for the help!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi, WilmaB

     

    According to your decsription, you want to import the date which is accurate to the millisecond into PowerBI, right? However, this kind of data type is not supported in PowerBI. The data in Date/Time format should be like  "5/11/2015 2:59:58 AM". So, your requirement cannot be achieved currently.

     

    Thanks,
    Yuliana Gu