cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Top Solution Authors
Top Kudoed Authors (Last 30 Days)