0 out of 1 rated this helpful - Rate this topic

ISBLANK Function

SQL Server 2012

SQL Server 2008 R2

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.

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 Labels	Total Sales	Total Sales Previous Year	Sales to Previous Year Ratio
2005	$10,209,985.08
2006	$28,553,348.43	$10,209,985.08	179.66%
2007	$39,248,847.52	$28,553,348.43	37.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])

Other Resources

Information Functions (DAX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD