Is it possible to convert a column in Power BI that contains a C# Date tick value to a DateTime?
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.
Check this one, more about....date conversion
Try the following conversion
The FromFileTime counts the ticks from 1600/01/01 so that's why we have the duration of 584388 days to offset this.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!