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

ISBLANK Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Checks whether a value is blank, and returns TRUE or FALSE.

Syntax

ISBLANK(<value>)  

Parameters

TermDefinition
valueThe value or expression you want to test.

Return Value

A Boolean value of TRUE if the value is blank; otherwise FALSE.

Example

This formula computes the increase or decrease ratio in sales compared to the previous year. The example uses the IF function to check the value for the previous year's sales in order to avoid a divide by zero error.

Row LabelsTotal SalesTotal Sales Previous YearSales to Previous Year Ratio
2005$10,209,985.08
2006$28,553,348.43$10,209,985.08179.66%
2007$39,248,847.52$28,553,348.4337.46%
2008$24,542,444.68$39,248,847.52-37.47%
Grand Total$102,554,625.71
//Sales to Previous Year Ratio  
  
=IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales])  
   , BLANK()  
   , ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] )  
      /'CalculatedMeasures'[PreviousYearTotalSales])  

See Also

Information Functions (DAX)

© 2018 Microsoft