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"
)
Something like this?
Switch ( true ( )
, [field1] = blank() && [field2] = blank() , "double oops"
, [field1] = blank() , "type-1 oops"
, [field2] = blank(), "type-2 oops"
, "Undefined"
)
That seems to have done the trick thank you very much. That pesky double ampersand always catches me out - I was trying to incorporate AND statements but your suggestion seems to have worked. Thank you