Contain Word

[AllanBerces]

Hi can someone help me on my calculated column, If the column Name contain SCREW then 0 if

not blank

Name	Result
SILICON RTV SEALANT 75 GM TUBE
BLT HEX,A1082-UNS S32760,UNC,50MM,M16
PNL FLR BAR MET 33/100 1219MM 905MM
SCREW HEX HD,SS316,METRIC,20mm,6mm	0
SILICON RTV SEALANT 75 GM TUBE
BLT HEX,A1082-UNS S32760,UNC,50MM,M16
OGLAEND SCREW,1371326,SS,M10X25,100/PK	0
BOLT,U,OGLAEND,1302409,M10,2in,62mm
SCREW HEX HD,SS316,METRIC,20mm,6mm	0
TRAY,CABLE,1371751,OGLAEND
TIE,CBL,MULTI-LOK,150x7mm,AE611,BAND-IT
SCREW HEX HD,SS316,METRIC,20mm,6mm	0
SCREW,PAN HEAD,OGLAEND,200/PACK,1372157,M6X20	0
SFTP, SCREW STL,25mm,10	0
PAN HEAD SCREW,OGLAEND,200/PACK,1372157,M6X20	0
SCREW HEX HD,SS316,METRIC,20mm,6mm	0

[pallavi_r · Accepted solution]

Hi @AllanBerces 

Please find the code below to get the expected output.

Corrected Expected Result =

IF(

    CONTAINSSTRING('Inventory Data'[Name], "SCREW"),

    0,

    BLANK()

)

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi

[AllanBerces]

Hi @pallavi_r if i want to add other word aside from SCREW, how does dax look like. let say SCREW and SILICON

[Ashish_Mathur]

Hi,

Do you want to see 1 if both those words are available in the cell or do you want a 1 if anyone of those is available?

[AllanBerces]

Hi @Ashish_Mathur @pallavi_r anyone of those word is avialable. thank you

[Ashish_Mathur]

Try this

=IF(OR(CONTAINSSTRING('Inventory Data'[Name], "SCREW"),CONTAINSSTRING('Inventory Data'[Name], "SILICON)),0,BLANK())

[AllanBerces]

Hi @pallavi_r thank you very much