Forum Discussion

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
2 years ago
Solved

Export in csv

Hi, I need to export a column in text format. The column is something like this: A,B ,C ,4.1, 4.2   If I export is CSV with power bi desktop and I open the CSV in excel type I have this format ...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Hello Giada90,

     

    Can you please try this:

     

    1. Transform the Column to Text

    FormattedColumn = FORMAT('YourTableName'[YourColumnName], "0.0")

    2. Add a Prefix to Force Text Interpretation in Excel

    ExportColumn = "'" & FORMAT('YourTableName'[YourColumnName], "0.0")

    Hope this helps.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello Giada90,

 

Can you please try this:

 

1. Transform the Column to Text

FormattedColumn = FORMAT('YourTableName'[YourColumnName], "0.0")

2. Add a Prefix to Force Text Interpretation in Excel

ExportColumn = "'" & FORMAT('YourTableName'[YourColumnName], "0.0")

Hope this helps.

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
2 years ago

thanks