Power Fx function
AddColumns — Power Fx function reference
Add a calculated column.
Syntax
powerfx
AddColumns( Table, NewColumn1, Formula1 [, NewColumn2, Formula2, ... ] )
Examples
powerfx
AddColumns(Staff, "Full", First & " " & Last)
→ Table with column
powerfx
AddColumns(Staff, "FullName", First & " " & Last, "IsManager", !IsBlank(DirectReports))
powerfx
AddColumns(Orders, "DaysOld", DateDiff(Created, Today(), TimeUnit.Days))
Common mistakes & gotchas
- AddColumns does not modify the original table or data source — it returns a new in-memory table; use Patch/Collect if the calculated value needs to be persisted.
- Formula can reference existing columns on the row, but not a column being added earlier in the same call — chain multiple AddColumns if one calculated column depends on another.
Related Power Fx functions
From Table shaping