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

            )

        )

    )

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