Table.FilterWithDataTable
TableInternalFilters a table using a data table identifier. Intended for internal use only.
Syntax
Table.FilterWithDataTable(table as table, dataTableIdentifier as text) as anyParameters
| Name | Type | Required | Description |
|---|---|---|---|
table | table | Yes | The input table to filter. |
dataTableIdentifier | text | Yes | An identifier for the data table used in filtering. |
Return Value
any — The filtered table result.
Remarks
This function is intended for internal use only. It is part of the Power Query engine's infrastructure for applying data table-based filters and is not designed for use in user-authored queries. Its behavior may change without notice between Power Query versions.
For filtering tables in your own queries, use Table.SelectRows with a row filter condition instead.
Examples
Example 1: Recommended alternative — use Table.SelectRows
Table.SelectRows(Sales, each [Category] = "Widgets")Output
OrderID | Product | Category | Quantity | UnitPrice | CustomerID | OrderDate | |
|---|---|---|---|---|---|---|---|
| 1 | 1 | Widget A | Widgets | 10 | 25.50 | 1 | 1/15/2024 |
| 2 | 5 | Widget A | Widgets | 20 | 25.50 | 1 | 2/20/2024 |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks