Create conditional column based on null values

[Anonymous]

A newbie is having problems with creating a new column - I just right click on my table (not in Power Query) and create new column and want a simple condition column:

Is Customer = IF(Orders[customerNumberShop] = null , 1, 0)

Which gives me an error, do I need another way to make it? I am trying to avoid Power Query because it is a large data set to refresh

[Ahmedx · Accepted solution]

try this

Is Customer = IF(Orders[customerNumberShop] = "" , 1, 0)
or
Is Customer = IF(Orders[customerNumberShop] = BLANK() , 1, 0)

or

Is Customer = IF(ISBLANK(Orders[customerNumberShop]), 1, 0)

[Fowmy]

@Anonymous 

Is Customer = IF( isblank(Orders[customerNumberShop] ), 1, 0)