Epoch Timestamp in milliseconds cannot convert to Date / Time

[moltra]

I am pulling in multiple Epoch Timestamp in milliseconds into Power Bi, for somereason Power Bi is displaying it as Scientific Notation.  ie 1584255600085 is showing as 1.58426E+12  I am trying to convert it to a Date Time format, but I keep getting errors.

I tried this formula that I found on another post on here. using this in a Custom Column.

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0,[epoch]/1000)

But I get the follow error.

Expression.Error: We cannot apply operator / to types Record and Number.

I have tried changing the formating of the column to number, decimal and still getting an error.

Any help would be greatly appreciated.Details:
Operator=/
Left=
epochDate=1.58426E+12
Right=1000

[az38 · Accepted solution]

Hi @moltra 

for me it works as appropriated

I think not all of your [epoch] value has a right format. check it

[moltra]

I applied all the transformation that I had done on the data and then went back into Transform data and tried it again and it worked perfectly.  I am not sure what was causing it.  But thanks for your rapid response.