Create a Calculated Measure

Follow these steps to create a new calculated measure to use in Power BI reports.

  1. In the Power BI report editor, select Calculated Measures.
    The Manage Calculated Measures window opens.
  2. Select Add New.
  3. In the Name field, provide a descriptive name for the measure.
  4. In the Home Table field, choose which table the calculated measure will display under in the Power BI report editor.
  5. In the Format field, choose which number format you want the calculated measure to display from among these options.
    • General Number displays the number with no formatting. For example, 12345.67.
    • Currency displays the number with your currency locale formatting. For example, $12,345.67.
    • Fixed Decimal displays at least one digit to the left of the decimal separator and two digits to the right of the decimal separator. For example, 12345.67.
    • Standard displays at least one digit to the left of the decimal separator and two digits to the right of the decimal separator, and includes thousand separators. For example, 12,345.67 is the standard United States number formatting.
    • Percent displays the number as a percentage (multiplied by 100) with formatting and the percent sign at the right of the number separated by a single space. For example, 1,234,567.00 %
    • Scientific displays the number in scientific notation with two decimal digits. For example, 1.23E+04.
  6. In the Decimal Places field, choose whether you want to display 0, 1, or 2 decimal places.
  7. Use the Data list, Functions list, and mathematical operators (*, +, -, /, (, )) to create your calculated measure.
    See Power BI Field Definitions for an explanation of specific measures and see Calculated Measures for definitions of the functions.
  8. Select Save Calculated Measure.
Your calculated measure is validated before it is saved. If any errors are detected, you must correct them then select Save Calculated Measure again. If no errors are detected, your calculated measure is created and can be used in Power BI reports across your organization.
Note: Your new calculated measure will display as processing until it is ready to use. Once it is, you will receive a notification in both the Manage Calculated Measures window and the Trimble Construction One notifications drawer.
Select Refresh in your Power BI report to display your new calculated measure in the data column.
CAUTION: Do not refresh your browser tab, as this will cause you to lose any unsaved changes to your open Power BI report.