Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom Column - handle comparing multiple null columns

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] = nul...
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Nolock
Resident Rockstar
7 years ago

Hi Anonymous ,

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    • Nolock's avatar
      Nolock
      Resident Rockstar
      7 years ago

      Great to hear about that :smileyhappy: