Need Help : Converting Long Data type Unix epoch Date/time column to Date time in Power Query

[Anonymous]

Hi Community, 

This is probably an easy ask. But i am unable to find a way to convert them to Date time data type. I have a data coming from API and a column of Long data type Unix epoch date time . 

How it looks like in Power Query : 

I want that to be converted as Date time data type (mm-dd-yyyy) format. 

Thanks,

G venkatesh 

[HotChilli · Accepted solution]

Ruth shows how:

https://www.youtube.com/watch?v=IEHq-rUcf-g 

[HotChilli]

Try searching the forums for "Unix epoch". I've definitely seen this answered.  It's something like "divide by a constant and add to date from 1970"