Forum Discussion

mitiefjn's avatar
mitiefjn
Advocate I
7 years ago
Solved

Export to excel date always includes time

Using PBI Desktop, I have a report with several date columns, however, even though I set the Data Type to Date (without time) and the Format to my desired Date setting, when I import the CSV file int...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    mitiefjn,

    There are two methods for you.

    1. Change the data type of the date column to Short Date in Excel file.


    2. Create a calculated column in Power BI Desktop using DAX below, then export visual to csv.

    Date= FORMAT(Table1[DateCol],"mm/dd/yyyy")



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

mitiefjn,

Yes. You would need to create 6 columns to convert the date columns to text format.

Regards,
Lydia

mitiefjn's avatar
mitiefjn
Advocate I
7 years ago

Thanks Lydia, in that case I'll stick to the Excel method until/if the export process is tidied up

 

Regards

Fred