Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Helllo everyone.
Does anyone know a way to convert GA datetime format to a proper format?
I believe their format is: YYYY/MM/DD/HH/MM
Solved! Go to Solution.
@Roberto456
Create the following column:
new date/time =
Var date_ = DATE(LEFT([GA datetime],4),RIGHT(LEFT([GA datetime],6),2),RIGHT(LEFT([GA datetime],8),2))
Var time_ = TIME(LEFT(RIGHT([GA datetime],4),2),RIGHT([GA datetime],2),00)
Return date_+ time_
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Roberto456
Create the following column:
new date/time =
Var date_ = DATE(LEFT([GA datetime],4),RIGHT(LEFT([GA datetime],6),2),RIGHT(LEFT([GA datetime],8),2))
Var time_ = TIME(LEFT(RIGHT([GA datetime],4),2),RIGHT([GA datetime],2),00)
Return date_+ time_
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |