Preserving Date format without 12:00:00 AM

[Anonymous]

Hi,

I have large table that I need to export out of Desktop into csv for some users.  Even though I used Power Query to change everything to a type of date, when I go to export this into CSV I get the below result. Is there any way to fix this? 

Thanks

Date

1/1/2025 0:00

2/1/2025 0:00

3/1/2025 0:00

4/1/2025 0:00

5/1/2025 0:00

6/1/2025 0:00

7/1/2025 0:00

8/1/2025 0:00

9/1/2025 0:00

10/1/2025 0:00

11/1/2025 0:00

12/1/2025 0:00

[Anonymous · Accepted solution]

Hi @Anonymous 

You can use the Format function to enforce a specific format on the date column.

Column = FORMAT('Table'[Date],"mm/dd/yyyy")

Result:

             

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samratpbi]

Hi,

I think you are exporting from Power BI desktop. Can you please change the format to date and export from Service and see if the issue persists?

if this helps to resolve your problem, then mark it as solution, thanks

[Anonymous]

Thanks. Unfortunately the client is very new to Power BI and I don't have Service or Gatewawys set up for them.   Is there a way to do in Desktop?

[parry2k]

@Anonymous change the format of the date column without time from the format drop down list.