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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Sang23041983
New Member

Time stamp

Time

12:15
08:30
16:00
120:40:00
 200:30:00

 

This is my input , After loaded into Power query editor 

Time

12:15:00
08:30:00
16:00:00
00:40:00
 08:30:00

The output is like above value.

 

Can anyone please help, how I will get the same value after loaded into power query editor.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Sang23041983 

 

Try delete the step : Changed Type in power query

vjialongymsft_0-1704783483537.png

 

This is the result

vjialongymsft_1-1704783528071.png

 

 

Best Regards,

Jayleny

 

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

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Sang23041983 

 

Try delete the step : Changed Type in power query

vjialongymsft_0-1704783483537.png

 

This is the result

vjialongymsft_1-1704783528071.png

 

 

Best Regards,

Jayleny

 

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

 

 

Greg_Deckler
Community Champion
Community Champion

@Sang23041983 Looks like you are changing the data type. Perhaps import it as a text column instead of converting it?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Imported as TEXT data type.  But the result is

 

31-12-1899 12:15:00
31-12-1899 08:30:00
31-12-1899 16:00:00
05/01/1900 00:40:00
08/01/1900 08:30:00

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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