Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi guys,I'm new to POWER BI, I got some trouble in date question.
This is my data.
1490787085874 // type of timestamps
and it should covert to
GMT: Wed, 29 Mar 2017 11:31:25.874 GMT
Should I code convert function to convert or use the orignal time convert? any suggestions?
Solved! Go to Solution.
thks, solved it.
UTCTime = VAR UnixDays = [UnixTime]/(60*60*24*1000) RETURN (DATEVALUE("1/1/1970")+UnixDays)
I set more 1000(ms) and it correct.
Please also see here which may be relevant
thks, solved it.
UTCTime = VAR UnixDays = [UnixTime]/(60*60*24*1000) RETURN (DATEVALUE("1/1/1970")+UnixDays)
I set more 1000(ms) and it correct.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |