Label all except

[Anonymous]

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

[PattemManohar · Accepted solution]

@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]

Cool!!!!

Thank you so much!!