DAX Information - ISEMPTY function



Description

Checks if a table is empty.

DAX ISEMPTY function is new in Excel 2016.

Syntax

ISEMPTY (<table_expression>) 

Parameters

Sr.No. Parameter & Description
1

table_expression

A table reference or a DAX expression that returns a table.

Return Value

TRUE or FALSE.

Example

= ISEMPTY (Events) 

This DAX formula returns TRUE, if there is at least one row and one column of data in the table - Events. Otherwise, it returns FALSE.

dax_functions_information.htm
Advertisements