topic Re: SSAS Format String in DAX Commands and Tips

SSAS Format String

maserr — Thu, 14 May 2020 10:44:12 GMT

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,

Re: SSAS Format String

ibarrau — Thu, 14 May 2020 11:51:27 GMT

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.

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,

Re: SSAS Format String

maserr — Thu, 14 May 2020 17:46:15 GMT

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

Re: SSAS Format String

Anonymous — Thu, 14 May 2020 18:31:20 GMT

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!!