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? 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Nolock's avatar
    Nolock
    Resident Rockstar
    7 years ago

    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'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.