Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
brett_walton
Helper II
Helper II

data and time merge issue

‎03-10-2017 05:47 AM

Hi all, 

 

I have a date field and a time field ... When I merge them (using the merge columns function, and inserting a space between the two AND than changing the field type to date and time the seconds from the time gets converted to 00 . So 3/2/17 09:07:16 is converted to  3/2/17 09:07:00  . 

 

Any ideas ? 

Thank you ... 

Labels:
Message 1 of 2
6,140 Views
0
1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

‎03-10-2017 07:28 AM

Sure: "merge columns" is primarily meant for text columns.

 

Date and time columns have their own menu option: Combine Date and Time.

 

Just take a look at this very short video.

Specializing in Power Query Formula Language (M)

View solution in original post

Message 2 of 2
7,472 Views
1 REPLY 1
MarcelBeug
Community Champion
Community Champion

‎03-10-2017 07:28 AM

Sure: "merge columns" is primarily meant for text columns.

 

Date and time columns have their own menu option: Combine Date and Time.

 

Just take a look at this very short video.

Specializing in Power Query Formula Language (M)
Message 2 of 2
7,473 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

View All