Forum Discussion

rdiazd73's avatar
rdiazd73
Helper I
6 years ago
Solved

SI con 3 condiciones

hola chicos
¿Puedo ayudarme por favor, mi fórmula no funciona bien, necesito un nuevo colum con resultado de texto / mover / mover lento / no mover
Tengo 3 colums en la misma mesa,
el que tenga el valor más alto de las 3 columnas debe ser el que obtenga el resultado
M/S/NO MOVER ?
IF('ANÁLISIS DE MOVERS LENTO'[NO MOVER]>'ANÁLISIS DE MOVERS LENTO'[MOVER];" NO MOVER";
IF('SLOW MOVERS ANALYSIS'[SLOW MOVER]>'SLOW MOVERS ANALYSIS'[MOVER];" SLOW MOVER";
IF('SLOW MOVERS ANALYSIS'[MOVER]>'SLOW MOVERS ANALYSIS'[SLOW MOVER];" MOVER")))
Captura.JPG

gracias de antemano 🙂

  • Anonymous's avatar
    Anonymous
    6 years ago

    Esta solución que utiliza iF anidados con Y funciona

    Gracias

    M/S/NO MOVER ?

    SI (

    'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[NO MOVER]

    && 'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER],

    "MOVER",

    SI (

    'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]

    && 'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER],

    "NO MOVER",

    SI (

    'SLOW MOVERS ANALYSIS'[SLOW MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]

    && 'SLOW MOVERS ANALYSIS'[SLOW MOVER] > 'SLOW MOVERS ANALYSIS'[NO MOVER],

    "SLOW MOVER",

    BLANCO ()

    )

    )

    )

4 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hola @rdiazd73

    utilizar SWITCH()

    M/S/NO MOVER =
SWITCH(TRUE();
'SLOW MOVERS ANALYSIS'[NO MOVER]>='SLOW MOVERS ANALYSIS'[MOVER];"NO MOVER";
'SLOW MOVERS ANALYSIS'[SLOW MOVER]>='SLOW MOVERS ANALYSIS'[MOVER];"SLOW MOVER";
'SLOW MOVERS ANALYSIS'[MOVER]>='SLOW MOVERS ANALYSIS'[SLOW MOVER];"MOVER";
BLANK()
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Esta solución que utiliza iF anidados con Y funciona

    Gracias

    M/S/NO MOVER ?

    SI (

    'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[NO MOVER]

    && 'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER],

    "MOVER",

    SI (

    'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]

    && 'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER],

    "NO MOVER",

    SI (

    'SLOW MOVERS ANALYSIS'[SLOW MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]

    && 'SLOW MOVERS ANALYSIS'[SLOW MOVER] > 'SLOW MOVERS ANALYSIS'[NO MOVER],

    "SLOW MOVER",

    BLANCO ()

    )

    )

    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      La solución que utiliza la función SWITCH es una mejor opción con las modificaciones a continuación...

      Gracias

      M/S/NO MOVER 2 ?

      INTERRUPTOR ( TRUE (),

      SUM ( 'SLOW MOVERS ANALYSIS'[NO MOVER] ) > SUM ( 'SLOW MOVERS ANALYSIS'[MOVER] ), "NO MOVER",

      SUM ( 'SLOW MOVERS ANALYSIS'[SLOW MOVER] ) > SUM ( 'SLOW MOVERS ANALYSIS'[MOVER] ), "SLOW MOVER",

      SUM ( 'SLOW MOVERS ANALYSIS'[MOVER] ) > SUM ( 'SLOW MOVERS ANALYSIS'[SLOW MOVER] ), "MOVER",

      BLANCO ()

      )

    • rdiazd73's avatar
      rdiazd73
      Helper I
      6 years ago

      gracias @glissando

      la mejor solución y los resultados más fiables es:

      M/S/NO MOVER ?
      SI (
      'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[NO MOVER]
      && 'SLOW MOVERS ANALYSIS'[MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER];
      "MOVER";
      SI (
      'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]
      && 'SLOW MOVERS ANALYSIS'[NO MOVER] > 'SLOW MOVERS ANALYSIS'[SLOW MOVER];
      "NO MOVER";
      SI (
      'SLOW MOVERS ANALYSIS'[SLOW MOVER] > 'SLOW MOVERS ANALYSIS'[MOVER]
      && 'SLOW MOVERS ANALYSIS'[SLOW MOVER] >' 'SLOW MOVERS ANALYSIS'[NO MOVER];
      "SLOW MOVER";
      BLANCO ()))))