Forum Discussion

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
2 years ago
Solved

How to create a calculated column with 2 condition

Hi everyone!

 

I want to set up a Calculated column which help me identify "high transfer" and "low transfer"

 

 If "Average Transfer Times" is greater than 30 and "# of Calls"  is greater or equal to 15 

the Column shows" High Transfer"

 

If "Average Transfer Times" is less than 3 and "# of Calls"  is greater or equal to 50

the Column shows" Low Transfer"

 

 

How can I create this calculated Column? 

 

 

Thanks in advance!

 

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi njxfoster 

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    Create a column

     

    Transfer Type = 
    IF(
        'Table'[Average Transfer Times] >30 && 'Table'[# of Calls] >= 15, 
        " High Transfer", 
        IF(
            'Table'[Average Transfer Times] < 3 && 'Table'[# of Calls] >= 50, 
            "Low Transfer", 
            BLANK()
            )
    )

     

    Here is the result

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

2 Replies

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi, njxfoster 

     

    Try below

    Column=

    Switch (

    True (),

    Tablename[Average Transfer Times]>30 && tablename[# of Calls]>=15,"High transfer",

    Tablename[Average Transfer Times]<3 && tablename[# of Calls]>=50,"low transfer")

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi njxfoster 

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    Create a column

     

    Transfer Type = 
    IF(
        'Table'[Average Transfer Times] >30 && 'Table'[# of Calls] >= 15, 
        " High Transfer", 
        IF(
            'Table'[Average Transfer Times] < 3 && 'Table'[# of Calls] >= 50, 
            "Low Transfer", 
            BLANK()
            )
    )

     

    Here is the result

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.