Forum Discussion
Solved
Export the Data from Power BI without Timestamp
Hi , Trying to extract the table data from Power BI to excel but in the date columns it is reflecting with Timestamp. I need only date range and timestamp sholud be removed while exporting the da...
Hi, sathishkumark24
Based on your information, I create a new sample table:
Then create a calculate column and try the following dax:
DateOnly = FORMAT('Table'[Original DateTime], "yyyy-mm-dd")Create a table visual and put DateOnly field in it, export data:
Open this file in Excel:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi sathishkumark24 , Hope you are doing good!
Make sure you change the datatype in Power Query editor.
I tried this and it's working fine.
If you still face the issue then please share a demo pbix file for better understanding.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!