Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Export Data Table

Hi all,

 

Happy New Year to everyone

 

I'm having an issue exporting a table from my report. I'm trying to export the data as it is shown below:

 

 

However, it is changing the format of the data in the 'Itemcode' colomn to the below and no change in excel seems to revert the data to how it was above:

 

 

Many thanks,

Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    Anonymous,

     

    Try creating a measure that adds a leading single-quote. This causes Excel to treat the value as text instead of converting it to a number.

     

    ItemCode Export = CONCATENATE ( "'", MAX ( Table1[ItemCode] ) )

     

    Add this measure to your visual and export to Excel:

     

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    Anonymous,

     

    Try creating a measure that adds a leading single-quote. This causes Excel to treat the value as text instead of converting it to a number.

     

    ItemCode Export = CONCATENATE ( "'", MAX ( Table1[ItemCode] ) )

     

    Add this measure to your visual and export to Excel: