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))
I bet Column From Examples would work here.
--Nate