ISBLANK DAX Function (Information)

Related articles

Learn more about ISBLANK in the following articles:

• How to handle BLANK in DAX measures

  This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could cause mistakes in a report using alternate expressions of the same calculation. Indeed, these expressions are not equivalent when BLANK is involved. » Read more

• Handling BLANK in DAX

  The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details the behavior of the blank value in DAX, highlighting a common error in DAX expressions […] » Read more

• Check Empty Table Condition with DAX

  In DAX there are different ways to test whether a table is empty. This test can be used in complex DAX expressions and this short article briefly discuss what are the suggested approaches from a performance perspective. » Read more

• Hiding future dates for calculations in DAX

  This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. » Read more

• Optimizing conditions involving blank values in DAX

  This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. » Read more

• From SQL to DAX: Implementing NULLIF and COALESCE in DAX

  This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. » Read more

• The COALESCE function in DAX

  COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose conditions, and yet obtain the same result. » Read more