Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Green_Boby
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

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
v-yuta-msft
Community Support
Community Support

Hi Green_Boby,

 

Create a measure using DAX formula as below:

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

捕获.PNG 

 

Regards,

Jimmy Tao

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

 

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

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

 

Thank you very much V-Yuta-Msft!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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