Convert Epoch/ Unix time to datetime in Power Query in one step!

In today's video, I am going to show you how what Epoch/Unix dates are and how to transform them to date/ time in power query and we are going to do that in one step only!

Chapters:
00:00 Intro and Problem description
00:27 What is Epoch time?
01:30 Convert Epoch/ Unix time into seconds
02:30 Add a date to a duration
04:10 How to do it in one step
Done!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[datagoose]

Wow thank you for that trick at the end about doing it in one step. Definitely will start doing that everywhere!

[josbar]

Thanks for this, but I got an error "Expression.Error: The Duration operation failed because the resulting duration falls outside the range of allowed values.", then I found in the community that I needed to divide the number by a 1000 to get the result +#duration(0, 0, 0, Number.From(_)/1000)

[MagoDigitalYT]

You are very very good at this. Congrats!!! And thanks a lot for your help and amazing content!

[benjamindonato]

Thank you so much! I have searched high and low for a solution. I also learned how it works from your video and will be subscribing.

[BrianStettenbenz]

Thank you for the wonderful tutorial. Do you have a tutorial that would provide insight on how to change multiple columns at once by editing the m-code?

[bradynelson]

Exactly what I needed, thanks for the video!

[joseagundis]

Gracias y buen año para usted también. Buen truco para iniciar el año, en lo particular no sabía como pasar de texto a número las fechas y me daban un error, ahora ya se como transformar (Number.From), Saludos Ruth

[tejasbrahmbatt]

Great trick to replace the M code and make it shorter..
May I ask, will a shorter code perform better?
Else, I would prefer a longer code that will be easier to understand..

[roshnisuhanda]

hey can you explain how can you
do this same thing in informatica expression ?

[novapulsar]

How about the reverse....date/time to epoch...

[bryanstark]

That was excellent! Do you have a Udemy course?

[nileshdhamale]

Hi
I have a time zone of +5.30 how can I add that ?

[Samadhan_Tidke]

Hi i am getting right ans but AM PM is not comming its 24 hr sysytem comming any sugeestion ??

[immanjohn]

Thanks a lot for making this video.... I got a value like when i extracted a date and time from xml file but i don't know how to convert it in to seconds. Can you please help me out on this... Thanks in advance...

[SS-lvpn]

Enter Data in a columb
11.5
12.5
13.5
14.5
And under transform data, round it to zero decimal places, and see the behavior, and explain the same in upcoming video

[chelynnes]

Seems lie it should work it keeps saying my duration time is out of range or something??