Function to find text with various parameters

[karinafreitass]

Hi guys! I have a column and I would like to find several values ​​and replace them in a new column.
I am using the following function: if Text.Contains ([Release], "Aplic") = true then "Application" else "Others".

How could I add more parameters?

Many thanks,

Karina

[aj1973 · Accepted solution]

Hi @karinafreitass 

use add clause in Add column inside Power Query

[aj1973 · Accepted solution]

Hi @karinafreitass 

use add clause in Add column inside Power Query

[karinafreitass]

The condition is only returning a parameter. It is returning all lines as "Others"

[aj1973 · Accepted solution]

If it helped, could you mark it as a solution for others in the community to know

Thank you