Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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")
Proud to be a PBI 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")
Proud to be a PBI Community Champion
Cool!!!!
Thank you so much!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |