cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
winter69
New Member

Convert C# date ticks to DateTime

Is it possible to convert a column in Power BI that contains a C# Date tick value to a DateTime?

2 ACCEPTED SOLUTIONS

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. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Thanks Matt.  I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.

View solution in original post

4 REPLIES 4
hugoberry
Responsive Resident
Responsive Resident

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.

bradnywells
New Member

Check this one, more about....date conversion

 

Wells

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. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Thanks Matt.  I suspected this was the direction I needed to go in, just wanted to be sure I hadn't missed something obvious.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors