DAX Information - ISEMPTY function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements