Convert date ticks to DateTime

[TahaSolutions]

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?

[hugoberry]

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.

[Greg_Deckler]

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