Forum Discussion
Solved
IF/AND/CONTAINS
I am trying to write the dax syntax to give me the following: if [Column A] CONTAINS "ABC" AND [Column B] = "123" then "Hello Mum" I can't seem to get the syntax right for 'contains' and 'and...
May be
= IF ( AND ( SEARCH ( "ABC", [Column A"], 1, 0 ) > 0, [Column B] = "123" ), "Hello Mum" )
May be
=
IF (
AND ( SEARCH ( "ABC", [Column A"], 1, 0 ) > 0, [Column B] = "123" ),
"Hello Mum"
)