BLANK DAX Function
Returns a blank.
Syntax
This expression has no parameters.
Return values
The BLANK value does not have a data type.
Remarks
The BLANK value is automatically converted in case it is compared with other values. The right way to check whether a value is BLANK is by using the ISBLANK function. Do not use the operator “=”. See related articles for more details.
Related articles
Learn more about BLANK 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
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/blank-function-dax