cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dotnet Frequent Visitor
Frequent Visitor

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User
Super User

Re: Date and Time format not recognized

Just split the column by a delimiter?

mnayar Established Member
Established Member

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.

dotnet Frequent Visitor
Frequent Visitor

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
Community Support Team

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

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.