Understanding visual calculations

Important

This content is archived and is not being updated. For the latest documentation, go to What is Power BI?. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Mar 13, 2024 -

Business value

Visual calculations allow users to create new calculations on a visual, using a simple interface based on a table of data, supported by powerful, easy to use formulas and Excel-like capabilities.

Feature details

Visual calculations allow users to build new calculations from any visual inside Power BI using an Excel grid-like interface. They allow users to use a grid to express their new formula and allow reference to other cells in the grid in order to derive a calculation. Most users today struggle to write and create DAX calculations of this nature, for example, running totals. In Excel, a user would simply reference the previous value from the cell. With these new visual calculation abilities, users would be able to leverage previous values, easily allowing them to build very complex formulas, very quickly.

Visual calculations edit mode showing a running sum calculation on profit over years.

See also

Using visual calculations (preview) (docs)