cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bgarland Helper I
Helper I

decompose datetime

This should be easy but being new to PowerBI I haven't found out how to do it yet. I have a column in a SQL Server table that I'm importing that contains a DateTime. I need to decompose this into two seperate columns, one that holds the date and another that holds the time.

 

2017-08-31_135224.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
MarcelBeug Community Champion
Community Champion

Re: decompose datetime

In the query editor, you find Date and Time options at the right hand side of both the "Add Column" tab and the "Transform" tab. These options include extracting date only and time only. They are available only if you first select your date/time column.

 

So you might add a column with time only and then transform the original column to date only.

 

Date only.png

Specializing in Power Query Formula Language (M)

View solution in original post

2 REPLIES 2
MarcelBeug Community Champion
Community Champion

Re: decompose datetime

In the query editor, you find Date and Time options at the right hand side of both the "Add Column" tab and the "Transform" tab. These options include extracting date only and time only. They are available only if you first select your date/time column.

 

So you might add a column with time only and then transform the original column to date only.

 

Date only.png

Specializing in Power Query Formula Language (M)

View solution in original post

bgarland Helper I
Helper I

Re: decompose datetime

Thanks!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors