SSAS Format String

[maserr]

Hi there,

I would like to format a SSAS measure as ‰ which is the 10*% and the available formats I can see on SSAS is Percentage, Whole number... maybe I could use the Custom one but don't know how to add the format of %.

Thanks in advance,

[harshnathani · Accepted solution]

Hi @maserr ,

You can try this.

Column = FORMAT((Table3[Material]*1000),0) & UNICHAR(137)

Regard,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[ibarrau]

Hi, there are two ways to change the format. From the menu and in the formula.

In menu click on your field to check the formula and go to the tab "Measure tools" or "Column Tools" . Then click on percentage symbol.

percentage symbol

With dax you can use the functions FORMAT with the word "Percentage" on it or another format you wish. This link contains format examples: https://www.tutorialspoint.com/dax_functions/dax_format_function.htm

Regards,

[maserr]

As I have explained, I am referring to ‰  not to %.