OR

[socialengaged]

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

[v-chuncz-msft · Accepted solution]

@socialengaged,

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)
}
, " | "
)

[socialengaged]

Thanks! It worked like a charm! 🙂