Measure Settings Dialog Box (Custom Aggregation)
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
The Measure Settings dialog box enables you to create or change a measure that uses a custom aggregation by typing a formula in the Data Analysis Expression (DAX) formula language. To access this dialog box, in the Excel window, on the PowerPivot tab, in the Measures group, click New Measure or Measure Settings.
A measure is a custom, dynamic calculation that you can create, and it is stored together with the data. Anyone who uses the PowerPivot workbook can see the measure and use it in calculations. For more information about measures, see Create a Measure in a PivotTable or PivotChart. Custom aggregations are those that are not based on the aggregations that you can create in a standard Excel PivotTable (SUM, COUNT, MIN, MAX, and AVERAGE).
Select a number format from the list. When you select the Currency, two decimals are automatically added to the Decimal Places box, and the currency symbol is applied to the Symbol box.
Enter how many decimal places you want the number to display.
Select the symbol you want to display with the numbers.
Use 1000 Separator
To use a digit-grouping symbol (such as a comma) to separate the thousand place, select Use 1000 separator (,). For example, check the box for 5400 to display as 5,400.