cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

si instrucción columna personalizada

Tengo una columna "Item" que me gustaría encontrar todos los valores comienzan con "SK" o "78", luego inserte un texto "No usar" en la columna personalizada, de lo contrario, lleve los valores de la columna Elemento como está. ¿Puede alguien ayudar con esto, por favor?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: if statement custom column

Hola @tracyhopaulson

Yo crearía una columna

_new_column de la imagen IF(LEFT([column],2) IN"SK"","78"-,"No usar",[columna])


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: if statement custom column

@tracyhopaulson

Puede crear una columna personalizada en Power Query para cumplir con la salida. La interfaz le permitirá elegir entre "contiene" (para especificar los valores de cadena) y la salida puede ser personalizada o un valor de columna





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted
Resolver III
Resolver III

Re: if statement custom column

Hola @tracyhopaulson ,

Proporcione datos de ejemplo.

Gracias

Highlighted
Resolver I
Resolver I

Re: if statement custom column

@Ajinkya369 adjuntar imagen de datos y el resultado que me gustaría lograr. Necesita ayuda con la fórmula Dax o la fórmula de columna personalizada por favor. Gracias.

sample.PNG

Highlighted
Community Champion
Community Champion

Re: if statement custom column

Hola @tracyhopaulson

Yo crearía una columna

_new_column de la imagen IF(LEFT([column],2) IN"SK"","78"-,"No usar",[columna])


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


View solution in original post

Highlighted
Super User II
Super User II

Re: if statement custom column

@tracyhopaulson 

 

Usando la función CONTAINSSTRING:

 

CONTAINSSTRING.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors