BLANK Function (DAX)

How does the BLANK function (DAX) work?

The BLANK function (DAX) returns a blank and it is an expression that has no parameters.

BLANK Formula Syntax

BLANK(
)

How do you use the BLANK function?

A BLANK is different from a NULL. In DAX, you may use a BLANK for both database nulls and for blank cells in Excel. Blanks and empty strings (“”) are not always equivalent, but some operations may treat them as such. 

Related Blog Posts

Related Support Forum Posts

How to ignore blank values in percentile calculation?
(Blank) gets added in Slicer
Date type and blank rows

Considerations when using the BLANK function

When you evaluate a DAX expression, a BLANK is converted to 0 or an empty string, depending on the data type requested by the said expression.  

Related Video Tutorials

Formula examples using the BLANK function

=IF( SUM(InternetSales_USD[SalesAmount_USD])= 0

BLANK () = 0

BLANK () && TRUE

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.