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' in the same sentence.
Any help much appreciated
May be
= IF ( AND ( SEARCH ( "ABC", [Column A"], 1, 0 ) > 0, [Column B] = "123" ), "Hello Mum" )
1 Reply
May be
= IF ( AND ( SEARCH ( "ABC", [Column A"], 1, 0 ) > 0, [Column B] = "123" ), "Hello Mum" )