Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add New Column (flag)

Hi world!

I came from the green side (Qlik) so I´ve found some problemns developing some "script" tasks that for sure you will help me

It´s really easy.

I want to add a new column (flag column) with values 0 and 1 when the following isntructions:

 

****Column ID is NULL  AND Column TYPE is different than the value "house"****

 

ID,TYPE,FLAG,
123house0
21232garage0
4235store0
24house0
 garage1
 store1
 house0
 garage1
 store1

 

In Qlik should be something like if(isnull(ID) and TYPE <>"house",1,0)  


But I am a beginner in DAX model so I need some help

Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    Try this formula

     

    Column = IF(LEN(Table[COLUMN_D])=0 && Table[TYPE] <> "house",1,0)

     

    OR

     

    Column = IF(Table[COLUMN_D]=BLANK() && Table[TYPE] <> "house",1,0)

     

5 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Try this formula

     

    Column = IF(LEN(Table[COLUMN_D])=0 && Table[TYPE] <> "house",1,0)

     

    OR

     

    Column = IF(Table[COLUMN_D]=BLANK() && Table[TYPE] <> "house",1,0)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      There is a problem with the formula the PBI says the following " Token RoghtParen expected"  and select the first coma "," --> 

      ,1,0)

       any idea?

      • themistoklis's avatar
        themistoklis
        Community Champion
        7 years ago

        Anonymous

         

        Where did you put the formula? It seems that you are creating a column using Power Query.

        This is a DAX formula.

         

        Also based on regional settings the comma can be replaced with semicolon ' ; '

  • Omega's avatar
    Omega
    Impactful Individual
    7 years ago

    Try 

     

    Flag = IF(ISBLANK(Table2[ID]) && Table2[TYPE,] <> "House",1,0)