Use custom dimensions in calculations

Microsoft Cloud for Sustainability Technical Summit May 2024

You can use custom dimensions in your calculation models. When writing PowerFx expressions, if custom dimensions are used in the entity, they're suggested via IntelliSense. For example, you can use custom dimensions in condition, calculation, and reporting actions.

Assuming you already defined and ingested data with custom dimensions, IntelliSense can guide you when you design a condition or calculation action.

Intellisense suggestions:

09.

Used in condition action:

10.

Used in calculate action:

11.

Note

There is no type validation during design, and calculations will fail with incompatible types such as if a string is used in numerical expressions.

See also

Extend the Cloud for Sustainability data model with custom dimensions
Custom dimensions dashboard