Parse timestamps to date

[RachC]

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?

[HJC-AC]

Please also see here which may be relevant

https://community.powerbi.com/t5/Quick-Measures-Gallery/Milliseconds-Duration/m-p/2752659/highlight/...

[Vvelarde]

@RachC

hi, check this link:

http://radacad.com/power-query-convert-time-stamp-to-date-time

[RachC · Accepted 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.