Conditional / logical IF

[p4nny]

Hi,

I'm trying write a conditional IF using the AND in dax but I'm really struggling

It should read as:

if(and(column1="NULL", column2="NULL", column3="NULL"), "delete", "retain")

I've tried if column1 = null and column2 and so on...

Thanks in advance

[Anonymous]

You have to know what it is you want to write - a measure or a calculated column. DAX is not Excel. By any means.