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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Springbok43
New Member

How to change a date field from date time to a date

I have a date field that has the short date plus 0:00 on the end when I export to Excel.  I did go to the relationships editor and change the type of the field to just date but when I export the data from the visual I still get that 0:00 in the field.  Because of this I am having trouble calculating the number of days in this field from Today()

Springbok43_0-1679347510844.png

Is there anything I can do to change this date type so that I can use it in an aging calculated column?

3 REPLIES 3
vicky_
Super User
Super User

You can try add a new column with the formula DateOnly = INT(Deadline Date) and change the column type to Date, or go into PowerQuery and change the type there. When you load, it will default to show all times as 12am, but you can then simply change the format.

Thanks Vicky.

I am still getting an error when I try and use it in a viz:

OLE DB or ODBC error: Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported

based on the error message that is a different problem. This thread suggests that the issue is using Direct Query mode - so either change mode or use a different way to merge tables.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.