Currency in a Analysis Services Calculated Measure

October 2, 2008

Ever needed to make a calculated measure have a display type of “Currency”?  Did you notice it wasn’t what you wanted?

Instead of choosing the drop-down box to “Currency”, you can type in your own.  You’ll notice that “#,#.00” is nearly what we want, but we need to add a “$”.  To finish up, you can type in “$#,#.00”.  Don’t forget to include the quotes just like the other ones.  If you’d like to get rid of the decimals, feel free to omit the .00 and just type in “$#,#”.