Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Nathant
Frequent Visitor

Converting UNIX timestamp to datetime

‎11-17-2023 04:20 AM

I have a UNIX timestamp being returned as 1635854750 which when putting into an online converter should be Tue Nov 09 2021 11:06:11 GMT+0000.

 

So i have created a custom column with the following query to convert.

 

#datetime(1970,1,1,0,0,0) + #duration(0,0,0,[data.resolved_time]/1000)

 

But this isn't yielding the result i'm expecting (row 1)?

Nathant_0-1700223578773.png

 

Am i missing something?



 

 

Labels:
Message 1 of 2
1,212 Views
0
1 REPLY 1
DOLEARY85
Resident Rockstar
Resident Rockstar

‎11-17-2023 09:20 AM

Hi,

 

Try removing the /1000 part of the formula,

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Message 2 of 2
1,186 Views

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All