Reply
Frequent Visitor
Posts: 2
Registered: ‎08-14-2018
Accepted Solution

Date and Time format not recognized

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.

 

 


Accepted Solutions
Community Support Team
Posts: 1,306
Registered: ‎06-24-2018

Re: Date and Time format not recognized

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:

1.PNG

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

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

2.PNG

 

Regards,

Daniel He

 

 

View solution in original post


All Replies
Highlighted
New Contributor
Posts: 423
Registered: ‎07-12-2017

Re: Date and Time format not recognized

Just split the column by a delimiter?

Established Member
Posts: 222
Registered: ‎07-13-2018

Re: Date and Time format not recognized

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

Frequent Visitor
Posts: 2
Registered: ‎08-14-2018

Re: Date and Time format not recognized

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

Community Support Team
Posts: 1,306
Registered: ‎06-24-2018

Re: Date and Time format not recognized

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:

1.PNG

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

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

2.PNG

 

Regards,

Daniel He