Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
@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?
Just split the column by a delimiter?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |