set condition

[Selim_Tuncay]

i want to set condition ([Islem]="MASRAF"and[Islem]='') but i cant take the  {islem]="" empty even no value inside of the column

thanks

IF(([Islem]="MASRAF"and[Islem]=''),"a",LOOKUP(
MAX(KisiSec[_ROWNUMBER]),
"KisiSec",
"_ROWNUMBER",
"Kategorix"
))

[dbaum]

I don't follow what you're trying to accomplish. The following might help.

• You can use the ISBLANK function to evaluate whether a column's value is blank.
• The AND function requires different syntax than you're using.
• The expression AND([Islem]="MASRAF", ISBLANK([Islem])) will always return false since the column cannot simultaneously equal MASRAF and be blank. Maybe you mean to use the OR expression.

[Selim_Tuncay]

if ( or([Islem]="MASRAF",ISBLANK([Islem])),"",LOOKUP(
MAX(KisiSec[_ROWNUMBER]),
"KisiSec",
"_ROWNUMBER",
"Kategorix"
))

thanks for help 

it works