Converting date formats

[WilmaB]

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

[DennisJung]

sd

[v-yulgu-msft]

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

[WilmaB]

Thank you Yuliana!

[BhaveshPatel · Accepted solution]

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

Split by Delimiter

[WilmaB]

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!