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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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