How to check if a column is empty or not.

How to check if a column is empty or not.

Consider the following dataset where the "Profession" column has a few empty rows.

Dataset:
Name Age Profession
sherlock 40 ""
Watson 38 Doctor One method to identify the empty values is by using a calculated column with the following expression:

If(Len([Profession])=0,"Empty","Not Empty")

The above expression calculates the length of the column "Profession". If if the length is 0, it will display "Empty" otherwise it will result in 'Not Empty".