Containsstring AND

[Anonymous]

Hello Everyone,

My goal is to change terms to "C" in two conditions:

1. If terms are A and Mat is X

2. If terms are B and column Mat contains a string XE (in its line item names)

I am confused if my usage of Containsstring is right in this case. Please help me out!

Column = if(

(

(Table[TERMS] = {"A"} && Table[Mat] in {"X"})

|| (Table[TERMS] = {"B"} && CONTAINSSTRING(Table[Mat],"XE")

),

C,

TABLE[TERMS]

)

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

There are some minor errors in format. 

The table name is recommended to be enclosed in quotation marks, and the values "A", "B", "C"  only  need to be enclosed in quotation.

colummn =
IF (
    ( 'Table'[TERMS] = "A"
        && 'Table'[Mat] IN { "X" } )
        || (
            'Table'[TERMS] = "B"
                && CONTAINSSTRING ( 'Table'[Mat], "XE" )
        ),
    "C",
    'Table'[TERMS]
)

PS:You can check whether there is an error in the sentence through this website, but the specific error still has to be debugged by yourself
http://www.daxformatter.com/

Best Regards,
Community Support Team _ Eason

[Anonymous]

HI @Anonymous 

Column = if(((Table[TERMS]="A" && Table[Mat]="X")||(Table[TERMS] = "B" && FIND("XE",Table[Mat])>0),
C,TABLE[TERMS])

 FiND is a better option in this scenario as CONTAiNSSTRiNG is used to match patters and we are not looking for a pattern.

[Tahreem24]

Well, it looks correct. Are you facing any issue while writing that dax?

[az38]

@Anonymous 

why not? it looks correct but i would write it as

Column = if(
(
(Table[TERMS] = "A" && Table[Mat] = "X")
|| 
(Table[TERMS] = "B" && CONTAINSSTRING(Table[Mat],"XE")
),
C,
TABLE[TERMS]
)