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...
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:

     

     

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: