Forum Discussion
Anonymous
7 years agoNot applicable
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
- PattemManoharCommunity 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")
- AnonymousNot applicable
Cool!!!!
Thank you so much!!