Forum Discussion
Convert data type E+12 to Time Stamp
Hello
I've used an API to pull New Relic data into Power BI and there is a column called Timestamp.1 which holds values that look like 1.5713E+12 and so forth. I tried converting to anything besides decimal number and it errors.
Can I transform or add a new column to retrieve a time/date value?
Hi,
If you want to convert it to datetime you could try the solution provided in this post
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Timestamp.1]/1000)
5 Replies
You have to use Split Column option. CAn you please share 2 or 3 Exact Values in each cell. Then I can explain thru screenshots
Hi VijayP
Three values:
1571264722889
1571304319052
1571264722889
Strange I was able to get these by pasting into Excel, they converted to number no problem. Power BI will not allow me to convert the truncated value.
Thanks for helping me!
Jemma
Hi,
If you want to convert it to datetime you could try the solution provided in this post
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Timestamp.1]/1000)
