IF, BLANK, & AND statements combined

[DMB90]

I am trying to create the following DAX in a column and it's not working properly for me. I would appreciate some assistance.

If "Process Column" is BLANK and "Control Type Column" is "Control", then "1", if not, then "0"

[Kedar_Pande]

@DMB90 

NewColumn = 
IF(
ISBLANK('YourTable'[Process Column]) && 'YourTable'[Control Type Column] = "Control", 
1, 
0
)

[mariussve1]

Hi,

Why did you accept solution on the latest post and not my first post when I wrote exactly the same?

[PhilipTreacy]

Hi @mariussve1 

Your code had errors.  It didn't have [ ] around the column names and it was missing the closing " around the text string.  If the OP tried that code it would have generated errors.

Regards

Phil

[PhilipTreacy · Accepted solution]

@DMB90 

Two options:

= IF( AND( ISBLANK([Process Column]), [Control Type Column] = "Control"), 1, 0 )

= IF( ISBLANK([Process Column]) && [Control Type Column] = "Control", 1, 0 )

regards

Phil

[mariussve1]

Hi,

Could you try:

If ( and ( isblank ( Process Column ), Control Type Column = "Control ), 1, 0 )