Forum Discussion
How to format Timestamp
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]
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
5 Replies
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
susheeltyagi You can create a new column . you can use below dax function
Time Stamp 1 = FORMAT(Sheet1[Time Stamp],"dd:mm:yyyy hh:mm:ss")
Give me kudos if find it useful .
