Forum Discussion
Convert date ticks to DateTime
I have seen this formula in another post.
Convert(datetime, (MachineGroups.TimeAdded - 599266080000000000)/864000000000)
Power BI doesn't have the convert function.
Can any one write this command in Power BI DAX language?
2 Replies
What type of dateticks do you have in terms of what is the reference date? You should be able to do the conversion using either Power Query "M" code or DAX:
https://msdn.microsoft.com/en-us/library/mt296606.aspx
https://msdn.microsoft.com/en-us/library/ee634786.aspx
Try the following conversion
=DateTime.FromFileTime([ticks])-#duration(584388,0,0,0)
The FromFileTime counts the ticks from 1600/01/01 so that's why we have the duration of 584388 days to offset this.
