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 colu...
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)

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ok I got it!!! I was trying to edit the query, I was in the wrong section.

    Thanks all for the responses,  BTW I needed ";" instead of "," 

    ;)