Forum Discussion
SSAS Format String
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,
Hi maserr ,
You can try this.
Column = FORMAT((Table3[Material]*1000),0) & UNICHAR(137)Regard,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
3 Replies
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,
As I have explained, I am referring to ‰ not to %.
Hi maserr ,
You can try this.
Column = FORMAT((Table3[Material]*1000),0) & UNICHAR(137)Regard,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
