How to create a calculated column with 2 condition

[njxfoster]

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!

[v-nuoc-msft · Accepted solution]

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.

[Dangar332]

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