Forum Discussion
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 th...
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 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")
Cool!!!!
Thank you so much!!