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.
Hello
Can you please help me out with this formula?
(if Text.Contains([Custom], "cloud", Comparer.OrdinalIgnoreCase) then "Cloud"
else if Text.Contains([Custom], "nuvola", Comparer.OrdinalIgnoreCase) then "Cloud"
else null) or (if Text.Contains([Custom], "ecommerce", Comparer.OrdinalIgnoreCase) then "ecommerce"
else if Text.Contains([Custom], "ecommerce", Comparer.OrdinalIgnoreCase) then "ecommerce"
else null)
The OR does not work. My wanted output should be
Cloud | ecommerce (for some cells)
Cloud (for some cells)
ecommerce (for some cells)
Thanks
Eugenio
Solved! Go to Solution.
You may add a custom column as follows.
= Text.Combine( { (if Text.Contains([Custom], "cloud", Comparer.OrdinalIgnoreCase) then "Cloud" else if Text.Contains([Custom], "nuvola", Comparer.OrdinalIgnoreCase) then "Cloud" else null) , (if Text.Contains([Custom], "ecommerce", Comparer.OrdinalIgnoreCase) then "ecommerce" else null) } , " | " )
You may add a custom column as follows.
= Text.Combine( { (if Text.Contains([Custom], "cloud", Comparer.OrdinalIgnoreCase) then "Cloud" else if Text.Contains([Custom], "nuvola", Comparer.OrdinalIgnoreCase) then "Cloud" else null) , (if Text.Contains([Custom], "ecommerce", Comparer.OrdinalIgnoreCase) then "ecommerce" else null) } , " | " )
Thanks! It worked like a charm! 🙂
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |