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
PhilipTreacy
Super User
Super UserHi 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
Thank you PhilipTreacy
This works! I appreciate you going through it in simple detail for me.