Calendar

[Anonymous]

hello everyone i'm actually working on power bi and i'm having this issu.

i have this kind of timestamp date :

20170701

20180708

20190609

please how can i convert it to a date time format ? 

thank you 

[Mariusz]

Hi @Anonymous 

In Query Editor you can change the Data Type of the column like below, as long as your current format is YYYYMMDD

Regards,
Mariusz

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

[Anonymous]

here is the error that i'm getting 

DataFormat.Error: We couldn't convert to Date.
Details:
20180522

[Mariusz · Accepted solution]

Hi @Anonymous 

Try Triming it first.

Regards,
Mariusz

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

[Anonymous]

it works ! thank you a lot for your help

[Anonymous]

HI @Mariusz  i did it, but all that i have is a column sur "Error" so i was wondering if there is a formula to get ta column in date time format

ps: i'm a begginer in power Bi 

thank u for ur answer tho