New DAX Measure/Column to return a String When a row is blank

[Anonymous]

I want to write a dax meaure or column(not sure of the best) to determine if "Sample count" is blank, or S'ize Value' is blank, or both 'Size value' and "Sample Count" is blank, their rows should return incomplete.

Atttached is a sample of my data. Thanks.

[Anonymous]

Thank you!

[tamerj1 · Accepted solution]

Hi @Anonymous 

You can create new column

Column =

IF ( ISBLANK ( TableName[Sample Cont] ) || ISBLANK ( TableName[Size Value] ), "Incomplete" )