Microsoft Dynamics 365 Customer Experience Analyst : Configure calculated and rollup columns
Calculated and rollup columns in Dataverse are powerful tools that allow you to automate data processing inside your tables without writing code or creating complex flows. A calculated column dynamically derives its value using formulas that reference other columns, related tables, or built-in functions—for example, automatically computing a customer’s full name by concatenating first and last names, or calculating an invoice’s remaining balance. A rollup column, on the other hand, aggregates data from related rows, such as summing total revenue from all opportunities linked to an account or counting the number of active cases for a contact. Rollup columns refresh either manually or on a schedule, ensuring performance is optimized for large datasets. Together, these features simplify business logic, improve data accuracy, and keep your Dataverse records up to date without external automation or custom development.
- In Power Apps, go to Dataverse → Tables.
- Choose the table where you want the column.
- Click + Add column.
- Enter a Display name, Name, and choose an appropriate Data type (e.g., Text, Number, Date).
- Under Advanced options, change Column type to Calculated.
- Select Open formula editor.
- Write your expression (e.g.,
If([Revenue] > 50000, "High", "Low")
- Click Save & Close, then Publish all customizations.
- Values are computed synchronously (instantly visible after save).
- Calculations cannot use aggregates across records — they work per record only.
- Supported in most client apps, SDK calls, and reports.
- In Power Apps, navigate to the desired table.
- Click + Add column.
- Choose a Data type compatible with rollups (Whole Number, Decimal, Currency, or DateTime).
- Change Column type to Rollup.
- Open the Rollup editor.
- Choose the related table (e.g., Opportunities for an Account).
- Select an aggregate function (SUM, COUNT, MIN, MAX, AVG).
- Add filters if needed (e.g., only include Active opportunities).
- System jobs (scheduled every hour by default).
- “Recalculate” button on a record.
- Programmatic calls to `CalculateRollupFieldRequest` in the SDK.
- Stored in the database, making queries faster.
- Updates are asynchronous to optimize performance.
- Best suited for totals, counts, or averages across related records.
- Use calculated columns for formulas needed in real time.
- Use rollup columns for aggregates or totals that don’t need immediate refresh.
- Minimize complex formulas or deep relationship chains to avoid performance issues.
- Test security roles: users must have read rights to referenced fields/tables.
Published on:
Learn moreWe can help you with Microsoft Dynamics 365 Customer Experience Analyst : Configure calculated and rollup columns
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Related posts
Copilot Studio: Agent Integration Approaches — Tools, Knowledge, and Agents
In Copilot Studio, agent integration employs the same fundamental integration concepts and patterns used in traditional enterprise integration...
Copilot Studio: How to Plan Integration with Enterprise Systems
Integrating Microsoft Copilot Studio agents with enterprise systems transforms a basic chatbot into a secure, intelligent digital teammate tha...
Book Review : The Manager 's Path : A Guide for Tech Leaders Navigating Growth and Change by Camille Fournier
After a long time, I came across a book that is truly valuable for engineering students and professionals, especially those working in t...
Power Platform Environment Deep Dive (Part 2)
In Microsoft Power Platform, choosing the right environment type is important because each environment is designed for a different business pu...
Power Platform Environment Deep Dive (Part 1)
Today, in the business enterpriese world, Power Platform enables organization to build application, automate workflow, analyze data crea...
Book Review : Life 3.0 by Max Tegmark
This is the third book I’ve read this year, and even though I’m still in the early chapters, it already feels like my favorite read of the yea...
Dataverse Views Demystified: Making Data Work for You
In Microsoft Dataverse, users do not always see all the data stored in a table. What they can view depends on their security permissions, role...
Decode & Fix : Shared App host initialization has timed out in Microsoft Power Apps
Issue :While working with apps in the Microsoft Power Platform, we encountered a critical issue where the application failed to load pro...