Forum Discussion

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago
Solved

Export data giving Special char

Hi Gurus,

 

Need a help. i have to display data using spaces as prefix based on condition .

i had used concatenate and unichar(127) to keep a space CONCATENATE(UNICHAR(127),[Column]). The problem is when exported to excel..it is showing up special characters. is there a chance to remove this while exporting or any way to keep a space where the special char wont show up.Please help

 

Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi ak77 
    You can use a space instead of the unichar in your Dax.
    CONCATENATE(" ",[Column]).

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    try using this code

    CONCATENATE ( UNICHAR ( 160 ),[Column] )

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi ak77 
    You can use a space instead of the unichar in your Dax.
    CONCATENATE(" ",[Column]).

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    try using this code

    CONCATENATE ( UNICHAR ( 160 ),[Column] )
    • ak77's avatar
      ak77
      Icon for Post Patron rankPost Patron
      2 years ago

      12288 and 160 worked well.. Thanks Ahmedx ..accepting as solution