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

Change Date + Time to Date only, online dataset

Hello,

 

My report is connected to a online dataset, shared with my account. Therefore, I cannot add any colum, or import another table for example.

However, I need to change or create a new colum replacing dates + times by dates only. Example: 13/06/2018 16:20 must now be 13/06/2018.

 

Do you think this might be done with a new measure with some FORMAT or DATE function? Couldn't find the solution...

 

Best regardsUnclick.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Change Date + Time to Date only, online dataset

Hi Green_Boby,

 

Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.

 

Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd") 

Regards,

Jimmy Tao

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Change Date + Time to Date only, online dataset

Hi Green_Boby,

 

Create a measure using DAX formula as below:

Measure = FORMAT(MAX(Table1[DateTime2Date]), "yyyy/MM/dd")

捕获.PNG 

 

Regards,

Jimmy Tao

Green_Boby Frequent Visitor
Frequent Visitor

Re: Change Date + Time to Date only, online dataset

Hello,

 

Thank you for your message. I tried to use your formula, but when I cannot select STD_DATES_MODIFIED (dates only) as a X axis on a graph, when I could for STD_DATES (date+time).

 

RegardsSTD.JPG

 

STD_MODIF.JPG

 

Community Support Team
Community Support Team

Re: Change Date + Time to Date only, online dataset

Hi Green_Boby,

 

Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.

 

Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd") 

Regards,

Jimmy Tao

View solution in original post

Green_Boby Frequent Visitor
Frequent Visitor

Re: Change Date + Time to Date only, online dataset

All right, I will see if I can do so in my file.

 

Thank you very much V-Yuta-Msft!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)