Custom Column - handle comparing multiple null columns

[Anonymous]

I have 15 columns. I want to create a custom column that checks if all 15 columns are not NULL to output either Complete or Incomplete

My logic is something like:

=

[ID] = null

or [NAME] = null

or [Application] = null

or [Application Type] = null

etc etc

then "Incomplete"

else "Complete"

But I always get Incomplete even though there are multiple rows with everything filled in.

Any ideas on how to structure that logic?

[Anonymous]

Can you post some sample data? 

[Anonymous]

Nick, I attached the sample table and sample formula i'm using

[Nolock]

Hi @Anonymous,

please check the 3rd message of this thread if it is the solution you expect. We published our post in the same time and maybe it was overseen.

[Anonymous]

Logically that looks perfect but a followup question is where would I input that logic?

I created a custom column and then I get this Custom Column prompt which I'll attach below. Within this prompt, I get errors trying similar logic as you posed to I'm guessing that I'm not entering the information in the right area?

[Nolock]

Hi @Anonymous ,

in PowerBI in tab Modeling click on New Column. And then insert the DAX code I've sent you.

[Anonymous]

Ah there we go. Thank you and I accepted the solution

[Nolock]

Great to hear about that 

[Anonymous]

[Nolock · Accepted solution]

Hi @Anonymous,

with the function ISBLANK you can check if there is any value.

BLNK =
VAR AnyBlank =
    ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] )
        || ISBLANK ( TestTable[Column3] )
VAR Result =
    IF ( AnyBlank; "Incomplete"; "Complete" )
RETURN
    Result