BLANK DAX Function in Power BI

The BLANK dax function returns a blank value. In Power BI, a "blank" represents an empty or null value. It’s commonly used in calculations, conditional logic, and data modeling to handle missing or undefined data gracefully.

DAX Syntax BLANK()

The BLANK() function takes no arguments. It simply returns a blank (null) value.

Example: Let’s create a measure with name “Blank dax Measure”.

DAX

The output of the above dax function is shown below:

Note: • BLANK is converted to zero when added to a number, but BLANK() + BLANK() = BLANK().
• A blank is not the same as 0 in DAX.

Let’s add the 0 to the BLANK() function.

DAX

The output of the above dax function is shown below:

DAX

The output of the above dax function is shown below: