Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

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

 

View solution in original post

5 REPLIES 5
Omega
Impactful Individual
Impactful Individual

Try 

 

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

@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
Not applicable

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

,1,0)

 any idea?

@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
Not applicable

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

😉

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.