Date format 1373895087

[Anonymous]

hi all,

i have a field called submitted date which contains this data: 1373895087 which should correspond to: 2013-07-15 15:31.

In my dataset i want to use this field as a date field (something like 20130715) any ideas how to do this?

hope you can help me with this

thanks

M

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

You can refer to these two similar threads: 

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

https://social.technet.microsoft.com/Forums/en-US/1d5b3cdf-012a-46f7-9fad-fbd45fd2e117/power-bi-calculating-a-datetime-from-a-timestamp?forum=powerquery

Best Regards,
Qiuyun Yu