Introduction to Power Fx formula columns

  • 2 minutes

This unit introduces formula columns that use Power Fx formulas to calculate the value for a table column.

Formula columns use the Power Fx language to calculate the value for the column. Formula columns are read-only.

Screenshot of editing the primary column.

The following data types are supported in formulas:

  • Single line of text

  • Decimal number

  • Date and time

  • Yes/no

Formula columns support intellisense that suggests functions and syntax, and even helps you fix errors.

The Calculated behavior will eventually be discontinued, so we recommend using the Formula data type for calculations instead.

For more information formula columns, see Work with formula columns.