Table.IsEmpty
Tells whether a table has no rows.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.IsEmpty(table as table) as logical| Parameter | Type | Description |
|---|---|---|
table | table | The table to look at. |
Returns
logical. true when the table has no rows, whatever its columns.
Examples
A table with rows
Table.IsEmpty(#table({"Product", "Price", "Units"}, {{"Chair", 50, 4}, {"Desk", 120, 1}, {"Lamp", 30, 6}}))falseNo row is left after a filter
Table.IsEmpty(Table.SelectRows(#table({"Product", "Price", "Units"}, {{"Chair", 50, 4}, {"Desk", 120, 1}, {"Lamp", 30, 6}}), each [Price] > 500))true