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

     

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: