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...
Greg_Deckler
Community Champion
Community ChampionWhat 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