DAX Function Guide

ISBLANK
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISBLANK work?
ISBLANK Function (DAX) checks if the value is null, and returns either TRUE or FALSE.
ISBLANK Formula Syntax
ISBLANK (<value>)
How do you use the ISBLANK?

ISBLANK returns true whenever its only argument is a blank expression.

Related Blog Posts

Loading

Considerations when using the ISBLANK?

When you use BLANK in a comparison, the conversion to 0 or to an empty string results in a positive match with these values. For this reason, comparing an expression to blank requires a specific function, ISBLANK, which returns true whenever its only argument is a blank expression.

Related Video Tutorials

Loading

Formula examples using the ISBLANK
//Sales to Previous Year Ratio

=IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales])
, BLANK()
, ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] )
/'CalculatedMeasures'[PreviousYearTotalSales])
Related Courses

Loading