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.
Is it possible to convert a column in Power BI that contains a C# Date tick value to a DateTime?
Solved! Go to Solution.
I am sure you could do it in Power Query.
Read this. http://stackoverflow.com/questions/1489243/how-can-i-convert-ticks-to-a-date-format
in Power Query, add a new column and then use the formula, above to convert the date tick to a serial number
I think you can then convert the number to a date with the UI (although I have never tried it). Worst case you should be able to use a power query date fipunction to convert it.
Thanks Matt. I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.
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.
I am sure you could do it in Power Query.
Read this. http://stackoverflow.com/questions/1489243/how-can-i-convert-ticks-to-a-date-format
in Power Query, add a new column and then use the formula, above to convert the date tick to a serial number
I think you can then convert the number to a date with the UI (although I have never tried it). Worst case you should be able to use a power query date fipunction to convert it.
Thanks Matt. I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |