Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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
  • Anonymous's avatar
    Anonymous
    1 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

  • Anonymous's avatar
    Anonymous
    Not 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.

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

     

     

  • 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's avatar
      Anonymous
      Not 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?