Date and Time format not recognized

[dotnet]

Hello all, i am new to this forumn, i am trying to work on a report with a CSV files containing data, one of the coloumn has date time and extra characters. For example below -04:00:00 are extra characters, what can i do in PowerBI to recognize it as DATE and TIME. 

Time Scanned

2018-08-02 07:39:04 -04:00:00 

I am looking for simple change in BI, as the CSV files gets changed every day. Please help. TIA.

[v-danhe-msft · Accepted solution]

Hi @dotnet,

Based on my test, you could split your column in query editor or with max:

In query editor:

Use the Split Column function:

If you want to use the dax, you could try:

Column = LEFT('Table1'[Time],20)

Regards,

Daniel He

[Anonymous]

@dotnet you could use right or left to get rid of characters if you know the length of it.

[dotnet]

Didn't get it, what is right or left. Are you talking about splitting them?

[jthomson]

Just split the column by a delimiter?