Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |