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?



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, privacy policy and cookie policy

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