Greg_Deckler
Community Champion
Community ChampionMilliseconds Duration
Based on the original blog post around Duration from 1/25/16 by konstantinos and later blogged about here:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
...
Building on this in a simpler format, if you have a timestamp in milliseconds and want to convert it to a datetime:ms, then please see below. This is also incorporating the work from here https://community.powerbi.com/t5/Desktop/Parse-timestamps-to-date/m-p/155179
UTCTime = VAR msTimestamp = 'table'[timestamp]
VAR UnixDays = msTimestamp/(60*60*24*1000)
VAR Milli = RIGHT(msTimestamp,3)
VAR DateTime = (DATEVALUE("1/1/1970") + UnixDays)
RETURN CONCATENATE (FORMAT(DateTime, "dd/mm/yyyy hh:MM:ss"), CONCATENATE( ":", Milli))