Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Here are a couple of quick calculations to convert Unix time to UTC time and vice versa.
Unix2UTC
Unix2UTC = VAR UnixDays = MAX([UnixTime])/(60*60*24) RETURN (DATEVALUE("1/1/1970")+UnixDays)
UTC2Unix
UTC2Unix = VAR __utc = [Unix2UTC] RETURN (__utc - DATEVALUE("1/1/1970"))*60*60*24
eyJrIjoiZjBkZmE5OGItMDg4MS00OGM1LWJkZmUtMGVhNjRmODU3M2M0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9
Thank you @Greg_Deckler . The first calculation worked for me, although I had to remove the MAX formula, and first had to extract the numbers from the /Date(, but otherwise perfect!