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.
Hi
I am new in Power BI. I need to format the Datetime from "2021-03-19T09:28:52.8090000Z" to "dd-MM-yyyy HH:mm:ss".
I am trying with below statemet but I am getting error
IngressTimestamp
2021-03-19T09:29:10.5510000Z |
= DateTime.ToText([IngressTimestamp],"dd-MM-yyyy HH:mm:ss")
Error :
Expression.Error: We cannot convert the value "2021-03-19T09:28:52...." to type DateTime.
Details:
Value=2021-03-19T09:28:52.8090000Z
Type=[Type]
Solved! Go to Solution.
If you are not going to make any timezone conversion I suggest you replace letter 'T' with space ' ' and also replace Z with nothing ''
You can do this by doing right click on column heading --> Replace values
First replace T with space ' ' (Press space once in 'Replace With' Box)
Second replace Z with nothing (Do not put anythin on 'Replace With' box)
Finally right click on column heading again --> Change Type to Date/Time
@susheeltyagi You can create a new column . you can use below dax function
@susheeltyagi , first of all, you should make the column IngressTimestamp is DateTime. if not change it datetime and then try this new column
Thanks for quick reply. BUt I am sorry how to make the column IngressTimestamp "2021-03-19T09:28:52.8090000Z" is DateTime ? I can create the new Custom Column but what the formulla ?
If you are not going to make any timezone conversion I suggest you replace letter 'T' with space ' ' and also replace Z with nothing ''
You can do this by doing right click on column heading --> Replace values
First replace T with space ' ' (Press space once in 'Replace With' Box)
Second replace Z with nothing (Do not put anythin on 'Replace With' box)
Finally right click on column heading again --> Change Type to Date/Time
Thanks dear its working now.. Great!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |