Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |