Units and Currency

You can set a column as a prefix or suffix for a given measure from the Measure Settings. This means that when the measure is added to reports, the units or currency will be displayed dynamically in each data cell.

This differs from static formats, which are set by applying one format mask to the measure. Static formats are useful if all the measure's values have the same unit or currency. If, however, the measure contains values with different units or currencies (like euros and dollars, for example), dynamic formatting should be used.

Note: this feature is not available in the Community Edition.

How to Set Dynamic Formatting

Dynamic formatting is set from the Measure Editor; set the prefix or suffix by choosing the required column from the relevant drop-down (green highlight below). The Prefix and Suffix columns will display the columns that are located in the same table as the given measure. This means that if your formatting column is stored in a different table, you must add a join to the relevant tables in the Data Flow.

  • Click here to learn about joins.

Format Prefix Column

Choose the column that lists the prefixes for the given measure.

Format Suffix Column

Choose the column that lists the suffixes for the given measure.