Forum Discussion
How to convert Milliseconds into a DateTime format?
I currently have a table of stored API data. Below I'm showing one seperate column with a few example rows that contain 13 digit Millisecond timestamps. How would I convert this into a DateTime forma...
Hi Anonymous
Download a sample PBIX file with data and code
Try the measure like this
Measure = DATEVALUE("1970-1-1") + MAX('Table'[Created]) /(60*60*24*1000)To give this
Regards
Phil
PC2790
Community Champion
Community ChampionHi Anonymous ,
See a similar thread: https://community.powerbi.com/t5/Desktop/How-Can-I-Convert-Milliseconds-Value-into-Date/td-p/361099
The measure suggested is : Measure = DATEVALUE("1970-1-1") + ('Created' /(60*60*24*1000))
Try and see if it works for you
Hello PC2790
Thanks for the suggestion, I did already go through that answer and the "Measure" wasn't recognised, neither was "DATEVALUE" when I tried to create a custom column of [Created] data.