Forum Discussion

rdiazd73's avatar
rdiazd73
Icon for Helper I rankHelper I
6 years ago
Solved

IF with 3 conditions

hello Guys
Can i help me please, my formula don´t working well , I need a new colum with  text result/ mover/slow mover/no mover
i have 3 colums in same table,  
the one with the highest value of the 3 columns must be the one that obtains the result
 
M/S/NO MOVER =
IF('SLOW MOVERS ANALYSIS'[NO MOVER]>='SLOW MOVERS ANALYSIS'[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")))
 

 

 

thanks in advance 🙂

Need Help
  • az38's avatar
    az38
    6 years ago

    hi rdiazd73 

    use 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
    6 years ago

    This solution using nested IFs with AND works

     

    Thanks

     

    M/S/NO MOVER =

    IF (

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

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

        "MOVER",

        IF (

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

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

            "NO MOVER",

            IF (

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

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

                "SLOW MOVER",

                BLANK ()

            )

        )

    )

4 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    hi rdiazd73 

    use 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

    This solution using nested IFs with AND works

     

    Thanks

     

    M/S/NO MOVER =

    IF (

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

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

        "MOVER",

        IF (

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

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

            "NO MOVER",

            IF (

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

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

                "SLOW MOVER",

                BLANK ()

            )

        )

    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The solution using the SWITCH function is better option with the modifications below...

      Thanks

       

      M/S/NO MOVER 2 =

      SWITCH ( 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",

          BLANK ()

      )

    • rdiazd73's avatar
      rdiazd73
      Icon for Helper I rankHelper I
      6 years ago

      thank you  Anonymous 

       

      the best solution and most reliable results is :

       

      M/S/NO MOVER =
      IF (
          'SLOW MOVERS ANALYSIS'[MOVER] >= 'SLOW MOVERS ANALYSIS'[NO MOVER]
              && 'SLOW MOVERS ANALYSIS'[MOVER] >= 'SLOW MOVERS ANALYSIS'[SLOW MOVER];
          "MOVER";
          IF (
              'SLOW MOVERS ANALYSIS'[NO MOVER] >= 'SLOW MOVERS ANALYSIS'[MOVER]
                  && 'SLOW MOVERS ANALYSIS'[NO MOVER] >= 'SLOW MOVERS ANALYSIS'[SLOW MOVER];
              "NO MOVER";
              IF (
                  'SLOW MOVERS ANALYSIS'[SLOW MOVER] >= 'SLOW MOVERS ANALYSIS'[MOVER]
                      && 'SLOW MOVERS ANALYSIS'[SLOW MOVER] >= 'SLOW MOVERS ANALYSIS'[NO MOVER];
                  "SLOW MOVER";
                  BLANK ())))