ISBLANK
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Checks whether a value is blank, and returns TRUE or FALSE.
Syntax
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.
Remarks
To learn more about best practices when working with BLANKS, see Avoid converting BLANKs to values in DAX.
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.
//Sales to Previous Year Ratio
= IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales])
, BLANK()
, ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] )
/'CalculatedMeasures'[PreviousYearTotalSales])
Result,
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 |
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho