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.

You should consider using formula columns in place of calculated columns.

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