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
Measures are written in the DAX language and need to be created from within the Data view of PBI Desktop.
From your screenshot it looks like you are writing the DAX in the Power Query editor but this only accepts the M language.
Regards
Phil
Thank you PhilipTreacy , I got confused. I'm currently creating a new measurement however, I can't direct it to just one column.
Measure = DATEVALUE("1970-1-1") + ('Created' /(60*60*24*1000))
On here the 'Created' part is asking for the table instead of the column. How do I make it specific for the 'Created' column?