Forum Discussion
Solved
IF and OR DAX needed
HI,
How can I create a custom column as follows. Formula needed.
IF [column A] = "APIP" or "APRS"
AND
[column B] = null
THEN
"Unplanned"
ELSE
"n/a"
Thanks.
m_roussakis , In DAX
IF([column A] in { "APIP", "APRS" } && isblank([column B]) ,"Unplanned" ,"n/a" )oror
or
IF(([column A] = "APIP" || [column A] ="APRS" ) && isblank([column B]) ,"Unplanned" ,"n/a" )
1 Reply
m_roussakis , In DAX
IF([column A] in { "APIP", "APRS" } && isblank([column B]) ,"Unplanned" ,"n/a" )oror
or
IF(([column A] = "APIP" || [column A] ="APRS" ) && isblank([column B]) ,"Unplanned" ,"n/a" )