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

Very good trick. Thanks for sharing!

Thank you!!!

Thank you

Great! Thank you!

For 10 digit Epoch/Unix time Power Query gives the correct datetime but I have imported the data from New Relic Web API which consist of timestamp as 13 digit as (1676629251256) and I am not able to convert this into datetime by Power Query, Kindly help to solve this query

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?

So helpful, thank you 😊

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

Excellent, Keep it up!

That was excellent! Do you have a Udemy course?

Thank you, you are legend!

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

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

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

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

Thank you! Perfect explanation!

Exactly solved my problem thanks

Thank you for posting...🙏

Exactly what I needed, thanks for the video!

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

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.

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

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

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

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

Feliz año para ti también

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