Forum Discussion
DAX Help With Nested If
Hello I hope a kind soul may be able to help me out. I am trying to convert the attached Cognos case statement into a DAX statement, in a caclulated column. I have been trying for a whole using a...
Something like this?
Switch ( true ( )
, [field1] = blank() && [field2] = blank() , "double oops"
, [field1] = blank() , "type-1 oops"
, [field2] = blank(), "type-2 oops"
, "Undefined"
)
Use Switch statement in DAX. It will solve your problem.