Formula column
A modern Dataverse column type using Power Fx for richer formulas than calculated columns — real-time evaluation, same trade-offs.
A formula column in Dataverse is a more recent column type that uses Power Fx (the same language as canvas Power Apps) for richer formula syntax than the older calculated columns. Formula columns evaluate at read time, so they're real-time like calculated columns but with substantially more available functions and constructs. Trade-offs: cannot reference related-table aggregations (use rollup columns for that), limited indexing for query performance, still subject to read-time computation cost. For most cases where calculated columns fall short of formula expressiveness, formula columns are the right upgrade. Verify target environment platform version supports them before deploying solutions that depend on them.