cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Función para encontrar texto con varios parámetros

¡Hola, chicos! Tengo una columna y me gustaría encontrar varios valores y reemplazarlos en una nueva columna.
Estoy usando la siguiente función: if Text.Contains ([Release], "Aplic") - true entonces "Application" else "Others".

¿Cómo podría añadir más parámetros?

Muchas gracias,

Karina

2 ACCEPTED SOLUTIONS
Memorable Member
Memorable Member

Hola @karinafreitass

usar la cláusula add en la columna Agregar dentro de Power Query

aj1973_0-1600200577417.png

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

View solution in original post

Memorable Member
Memorable Member

Si ayudara, ¿podría marcarlo como una solución para que otros en la comunidad lo conozcan

Gracias

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

View solution in original post

3 REPLIES 3
Memorable Member
Memorable Member

Hola @karinafreitass

usar la cláusula add en la columna Agregar dentro de Power Query

aj1973_0-1600200577417.png

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

View solution in original post

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

 

Screenshot (79).png

Memorable Member
Memorable Member

Si ayudara, ¿podría marcarlo como una solución para que otros en la comunidad lo conozcan

Gracias

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.