I have seen lots of examples but I can't find one that will do what I need. I have a 14 digit timestamp which I assume contains milliseconds that I need to convert into a proper date in a power pivot table. I am not sure if having to use a calculated column and DAX is what is causing the problem but all the formulas I have found don't quite work.
Here is an example of what I need: 14380003550847 should convert to July 27, 2015.
Bookmarks