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 ...
  • 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.

     

     

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.