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

parry2k's avatar
parry2k
Super User
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

    Thanks parry2k

     

    That is the answer I was expecting.