Forum Discussion
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.
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
4 Replies
v-danhe-msftMicrosoft Employee
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
jthomsonSolution Sage
Just split the column by a delimiter?
dotnet you could use right or left to get rid of characters if you know the length of it.
Didn't get it, what is right or left. Are you talking about splitting them?
