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

Can you post some sample data? 

 

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