Solved: Re: Convert Date format

qs · ‎04-26-2018

Hello all,
Let's go straight to the point.
I have a table with this type of date format: 1524728255. which stands for 2018/04/26 07:37.
I would like to know how can I convert 1524728255 into 26/04/2018 07:37?
Thanks for your help.

Q

MFelix · ‎04-26-2018

Hi @qs,

I'm assuming that you are refering to a date standard that counts the number of seconds since 1970 however looking at you post we don't have much information so it's difficult to get an answer (check this link by @Greg_Deckler)

However make a new column with the following code shoud work as you need:

Formated =
DATE ( 1970; 1; 1 )
    + ( Table1[Date] / 60
    / 60
    / 24 )

Regards,

MFelix

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

View solution in original post

MFelix · ‎04-26-2018

Hi @qs,

I'm assuming that you are refering to a date standard that counts the number of seconds since 1970 however looking at you post we don't have much information so it's difficult to get an answer (check this link by @Greg_Deckler)

However make a new column with the following code shoud work as you need:

Formated =
DATE ( 1970; 1; 1 )
    + ( Table1[Date] / 60
    / 60
    / 24 )

Regards,

MFelix

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

qs · ‎05-01-2018

@MFelix

Thanks for your solution. I will give a go with your suggestion and will keep you in the loop.

Best

Q

v-jiascu-msft · ‎05-08-2018

Hi @qs,

Did the solution work? Could you please mark the proper answer as solution?

Best Regards,
Dale

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