Power Fx function
Distinct — Power Fx function reference
Unique values from a column.
Syntax
powerfx
Distinct( Table, Formula )
Examples
powerfx
Distinct(Staff, Department)
→ Single-column table
powerfx
Distinct(Staff, Department)
powerfx
Sort(Distinct(Orders, Year(Created)), Value)
Common mistakes & gotchas
- Returns a column named Result.
- The output is always a single-column table with the column literally named "Result" — reference it as .Result, not the original column name.
- Distinct is not delegable on most connectors, so on a large SharePoint/SQL table it only finds distinct values within the non-delegable row limit.
Related Power Fx functions
From Filtering, search & sort