IF with 3 conditions

[rdiazd73]

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 🙂

[az38 · Accepted solution]

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 · Accepted solution]

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 ()

        )

    )

)

[rdiazd73]

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 ())))

[Anonymous]

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 ()

)

[az38 · Accepted solution]

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()
)