Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyContain Word
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 |
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
6 Replies
- pallavi_r
Super User
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
AllanBercesHi pallavi_r thank you very much
- 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?
