Add New Column (flag)

[Anonymous]

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

[Omega]

Try 

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

[themistoklis · Accepted solution]

@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]

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]

@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]

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

😉