Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
susheeltyagi
Helper I
Helper I

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]

 

 

1 ACCEPTED SOLUTION

@susheeltyagi 

 

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

View solution in original post

5 REPLIES 5
HarishKM
Impactful Individual
Impactful Individual

@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 .


amitchandak
Super User
Super User

@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 ?

@susheeltyagi 

 

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!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.