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

            )

        )

    )

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