Forum Discussion

RachC's avatar
RachC
Icon for Helper I rankHelper I
9 years ago
Solved

Parse timestamps to date

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?

Need Help
  • RachC's avatar
    RachC
    9 years ago

    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.

3 Replies