undefined

[Mideai]

 I have a problem with changing the numbers to date from 2012. Can I get help please, I'm stuck.

[AlexisOlson]

Assuming this is a Unix epoch timestamp, try

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Timestamp] / 1000)

as suggested in prior posts:
https://community.powerbi.com/t5/Desktop/DAX-to-convert-Epoch-to-DateTime/m-p/142287

https://community.powerbi.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Desktop/m-p/130...

[AlB]

Hi @Mideai 

What format are these dates on?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Mideai]

Time stamp is in Unix time

[Anonymous · Accepted solution]

Hi @Mideai ，

Please try to add the following custom column.

= #duration(0,0,0,[Timestamp])+#datetime(1970,1,1,0,0,0)

You can download my attachment for more details.

Reference: How to - Unix Timestamp conversions in Excel and Power Query - (theexcelclub.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.