Share via


ISBLANK Function (DAX)

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

ISBLANK(<value>)

Parameters

Term

Definition

value

The value or expression you want to test.

Property Value/Return Value

TRUE if the value is blank; otherwise FALSE (BOOL)

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 Labels

Total Sales

Total Sales Previous Year

Sales to Previous Year Ratio

2001

$10,209,985.08

 

 

2002

$28,553,348.43

$10,209,985.08

179.66%

2003

$39,248,847.52

$28,553,348.43

37.46%

2004

$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

Other Resources

Information Functions (DAX)