Forum Discussion

LUCASM's avatar
LUCASM
Helper IV
7 years ago
Solved

CASE Statement with Like

I need to replicate this SQL case statement in Power BI somehow.     CASE WHEN [PC Name] like '%ZENBUS%' THEN 'BUSINESS' WHEN [PC Name] like '%ZENWEB%' THEN 'ONLINE' WHEN [PC ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    LUCASM try this

     

    Type = 
SWITCH( TRUE(),
SEARCH( "AZN ZENBUS", Table2[col],,0) <> 0 , "Business",
SEARCH( "AZN ZENWEB", Table2[col],,0) <> 0 , "Online",
"Store"
)
LUCASM's avatar
LUCASM
Helper IV
7 years ago

Hi themistoklis

 

This solution has a similar problem to that of khader312

every row is the same rather than running through the IFs

could this be because every row starts with ZENUS and either has ZENBUS or ZENWEB also in the text

examples of full fields

ZENUSE AZN ZENBUS IT Needs to become "Business"

ZENUSE AZN ZENWEB IT Needs to become "Online"

ZENUSE AZN ZEN IT Needs to become "Store"

ZENBUS EU SARL Needs to become "Store"

 

Logic: Check the first two otherwise "Store"

 

Apologise if this was not clear first time around

Omega's avatar
Omega
Impactful Individual
7 years ago

Try: 

 

Column = Switch (True (), Contains (Table Name,[PC Name], "ZENBUS"), "BUSINESS",
      Contains (Table Name,[PC Name], "ZENWEB"),"ONLINE",
      Contains (Table Name,[PC Name], "ZENUSE"),"Store",
      [PC Name])