Forum Discussion

tkramer's avatar
tkramer
Advocate I
3 years ago

Search for multiple values with CONTAINS, not exact values

I have a request from an end-user for one of my reports.  He wants information on these 3 Product Numbers: VCBB5363, VCFB5363, VCRB5363.     Typically, I would put in a default Power BI slicer wh...
Need Help
AlbertoMelyov's avatar
AlbertoMelyov
Regular Visitor
1 year ago
Hey, this is kind of workarround 🙂
 
SubBrand = if(ISERROR(SEARCH("text1",D_Product[Product Long Name])),
if(ISERROR(SEARCH("text2",D_Product[Product Long Name])),
if(ISERROR(SEARCH("text3",D_Product[Product Long Name])),"Bars","BiteSize"),"BiteSize"),"BiteSize")