Forum Discussion

sathishkumark24's avatar
sathishkumark24
New Member
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.