Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
here is the error that i'm getting
DataFormat.Error: We couldn't convert to Date.
Details:
20180522
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |