Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Label all except

Hey guys

I'm trying to label some product here by their codes on my power query editor. 

I want to label every codes that starts with "21" except the ones that starts with "212".

Something like this:

if Text.StartsWith([#"CC#"] , "21") EXCEPT Text.StartsWith([#"CC#"] , "212") then "Product A"

if Text.StartsWith([#"CC#"] , "212") then "Product B"

 

Can anyone help me?

Thanks a lot

Pedro

  • Anonymous Please try this..

     

    = Table.AddColumn(#"Changed Type", "Result", each if Text.StartsWith([Data], "212") then "Product B" else if Text.StartsWith([Data], "21") then "Product A" else "Other")

2 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion

    Anonymous Please try this..

     

    = Table.AddColumn(#"Changed Type", "Result", each if Text.StartsWith([Data], "212") then "Product B" else if Text.StartsWith([Data], "21") then "Product A" else "Other")

    • Anonymous's avatar
      Anonymous
      Not applicable

      Cool!!!!

      Thank you so much!!