Use custom dimensions in calculations

Microsoft Cloud for Sustainability Tech Summit November 2024.

You can use custom dimensions in your calculation models. With 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.

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