Forum Discussion
14-digits Timestamp wrongly converted
Hi community! I have been transforming some data in my Power query to create some reports that I need for the univeristy, but I'm struggling trying to convert and 14-digits timestam to datetime: ...
Anonymous
Add this custom column, you can do the formatting after loading the query to the model as you need=Date.From(Text.Start([Timestamp],8))&Time.From(Text.End([Timestamp],6))
Fowmy
Super User
Super UserAnonymous
Add this custom column, you can do the formatting after loading the query to the model as you need
=Date.From(Text.Start([Timestamp],8))&Time.From(Text.End([Timestamp],6))
It works perfectly my friend! Thank you so much! 😄