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!
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
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:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@datagoose2931]

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

[@CurbalEN]

Once you start... you cant stop, you have been warned :)
/Ruth

[@bradynelson1955]

Exactly what I needed, thanks for the video!

[@MagoDigitalYT]

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

[@benjamindonato1555]

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.

[@CurbalEN]

Welcome to the channel !

[@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?

[@joseagundis1]

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

[@CurbalEN]

Tienes Number.From, Text.From, Date.From.... easy!!!

[@palashnandecha3199]

Exactly solved my problem thanks

[@sachingunjal7347]

Thank you for posting...🙏

[@gerardcaula5927]

Very good trick. Thanks for sharing!

[@faritr9988]

Thank you! Perfect explanation!

[@CurbalEN]

Wonderful!

[@sameerrazakhan4857]

Thank you, you are legend!

[@josbar80]

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)

[@arrossalex]

Great! Thank you!

[@AdamaDanjuma]

So helpful, thank you 😊

[@CurbalEN]

Pleasure!

[@robdoce2128]

Thank you!!!

[@roshnisuhanda7805]

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

[@504yousef]

Thank you

[@joangarcia6327]

Feliz año para ti también

[@CurbalEN]

Feliz año!

[@tejasbrahmbatt5344]

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..

[@CurbalEN]

It depends on what you are doing?
I prefer to merge my steps specially if it is intermediate steps, but thatbis just my preference:)

[@abdullahhasantufail4471]

Excellent, Keep it up!

[@CurbalEN]

🎊

[@nileshdhamale6297]

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

[@bryanstark324]

That was excellent! Do you have a Udemy course?

[@CurbalEN]

Thanks!
I have courses on my website:
curbal.com/courses-overview

[@novapulsar5559]

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

[@Samadhan_Tidke]

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

[@SS-lv8pn]

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

[@immanjohn3527]

Thanks a lot for making this video.... I got a value like 20210915030000(YYYYMMDDHHMMSS) 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...

[@chelynnes3013]

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