cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Frequent Visitor

## 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, 123 house 0 21232 garage 0 4235 store 0 24 house 0 garage 1 store 1 house 0 garage 1 store 1

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

1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: Add New Column (flag)

@Juampe

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 5
New Contributor

## Re: Add New Column (flag)

@Juampe

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)`

Established Member

## Re: Add New Column (flag)

Try

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

## Re: Add New Column (flag)

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

`,1,0)`

any idea?

New Contributor

## Re: Add New Column (flag)

@Juampe

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

Frequent Visitor

## Re: Add New Column (flag)

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 ","