Forum Discussion
Preserving Date format without 12:00:00 AM
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 |
- Anonymous1 year ago
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.
4 Replies
- AnonymousNot applicable
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.
- parry2k
Super User
Anonymous change the format of the date column without time from the format drop down list.
- samratpbi
Super User
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
- AnonymousNot applicable
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?