cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amtanner Frequent Visitor
Frequent Visitor

Date Separation - separating dates from timestamps

The data that I am using is importing as the following form "MM:DD:YYYY 00:00:00 __". (For example, "10/1/2015 12:00:00 AM".) I am not sure why it is doing this because the source of the data is simply in MM:DD:YYYY format. (I am importing this data from a SharePoint site, FYI.) How do I separate the date (MM:DD:YYYY) from the timestamp on the right side (00:00:00 __)? In the end, I am trying to zero in on the year, month, and quarter using a fiscal calendar but am unable to create the relationship between that calendar and the dates because of the timestamp attached. Suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Date Separation - separating dates from timestamps

Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Date Separation - separating dates from timestamps

Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Highlighted
Moderator v-sihou-msft
Moderator

Re: Date Separation - separating dates from timestamps

@amtanner

 

Or you can use Format() function to remove the timestamp part.

 

Column = FORMAT(Table[date],"MM-DD-YYYY")

Regards,

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 286 members 3,202 guests
Please welcome our newest community members: