Export data giving Special char

[ak77]

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

[Ritaf1983 · Accepted solution]

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 · Accepted solution]

try using this code

CONCATENATE ( UNICHAR ( 160 ),[Column] )

[ak77]

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

[Ritaf1983 · Accepted solution]

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