Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RachC
Helper I
Helper I

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?

1 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.

View solution in original post

3 REPLIES 3
HJC-AC
Frequent Visitor
Vvelarde
Community Champion
Community Champion

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.