ISBLANK

Syntax

ISBLANK(<value>)

Tutorial with example

Do you know the difference between zeros, nulls and empties?? Lets take a look at that so we can understand why we the power bi team introduced a new comparison operation, kindof..:

Download example files:

Download the pbix and excel file here.

Remarks

This formula computes the increase or decrease ratio in sales compared to the previous year. The example uses the IF function to check the value for the previous year’s sales in order to avoid a divide by zero error.