Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

IsBlank return with a specific value

Hello Experts,

 

I am trying to return null/blank fields with a specific variable. for example.

 

I have a calculated field with multiple "containstring" formula to group a specific category. 

CONTAINSSTRING(table name, "hospi"), "Hospitality"
 
I would like to return unknown category  with a variable called "Unknown" in same column. I tried isBlank function, But my calculated column name is not appearing under inBlank function
 
Would be great help if you could assist me with this.
 
thanks
 
if
Need Assistance
Need Help
Need Help DAX

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , not very clear. Try a new column like

    Switch(true(),
    isblank([column]) || [column] ="" ,"Unknown",
    search("hospi",[column],,0) >0, "Hospitality",
    "Other"
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak ,

       

      I've created a new calculated column to group categories and give a unique name. I would like to return "Unknown" in my calculated column wherever there's blank. I am unsure about some categories which was listed in main column. Hence I would like to return them as "Unknown". Current calculated column;

       

      SWITCH(TRUE(),
      CONTAINSSTRING (col1,"hospi") || CONTAINSSTRING(col2,"A0172") , "Hosiptals")
       
      I have several other categories which I've extracted/grouped them from other columns
       
      Can I include isblank function within same calculated column? If so then how?