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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership