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"
)
Omega's avatar
Omega
Impactful Individual
7 years ago

Create a column instead of a measure and try the below formula: 

 

Column = Switch (True (), [PC Name] = "%ZENBUS%", "BUSINESS",
      [PC Name] = "%ZENWEB%", "ONLINE",
      [PC Name] = "%ZENUSE%","STORE",
      [PC Name])
  • LUCASM's avatar
    LUCASM
    Helper IV
    7 years ago

    Hi khder312

    I'm not sure that works. All my results default to [PC Name].

    It maybe that this is because it is not a like but an equals even if we use "%xxxxx%"

     

    I do however agree with the column part of your solution which I just found.