Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.IsEmpty

Owen Duncan|Last Updated: 4/19/2018

About

Returns true if the table does not contain any rows.

Table.IsEmpty(table as table) as logical  

Arguments

ArgumentDescription
tableThe Table to check.

Example

let  

    emptyTable = Table.FromRows({}),  

     tableValue = Table.FromRows({{1,"Bob", "123-4567"}, {2,"Jim", "987-6543"}}, {"ProductID", "ProductName", "UnitPrice"})  

in  

[  

    IsEmptyTest1 = Table.IsEmpty(emptyTable),  

    IsEmptyTest2 = Table.IsEmpty(tableValue),  

    RowCount = Table.RowCount(tableValue),  

    ColumnCount = Table.ColumnCount(tableValue)  

]  

equals  
IsEmptyTest1true
IsEmptyTest2false
RowCount2
ColumnCount3
© 2018 Microsoft