OR

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.OrdinalIgno...

Need Help

v-chuncz-msft

8 years ago

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

v-chuncz-msft

Community Support

8 years ago

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

New Member

8 years ago

Thanks! It worked like a charm! :)

Forum Discussion

OR