I have a measure that show number in millions / billions.

The formatting of the number for now is like this : "$#,##0.0;-$#,##0.0"

I would like to format the number to show something like this:

If the Orginal number is: 117,100,000 $

I want to see it like that: 117.1 M $.

Can we do it on SSAS cube?


1 Answer 1


Please try this format string:

0,,.0 \M $

This trick is a bit buried in the documentation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.