Forum Discussion

JamesMoody's avatar
JamesMoody
Frequent Visitor
2 years ago
Solved

Custom Column with multiple if statements

I am wanting to add a column to my data to determine when a call is abandoned. Here is my currrent formula and the result I am getting.   Formula:  Column = IF('Table1'[Participant] = "agent", IF('...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Expected Result CC =
VAR _recordid = Table1[Record ID]
VAR _list =
    CALCULATETABLE (
        Table1,
        Table1[Record ID] = _recordid,
        Table1[Participant] = "agent",
        Table1[Segment] <> "alert"
    )
RETURN
    IF ( COUNTROWS ( _list ) = 0 && Table1[Segment] = "alert", "Abandoned" )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Expected Result CC =
VAR _recordid = Table1[Record ID]
VAR _list =
    CALCULATETABLE (
        Table1,
        Table1[Record ID] = _recordid,
        Table1[Participant] = "agent",
        Table1[Segment] <> "alert"
    )
RETURN
    IF ( COUNTROWS ( _list ) = 0 && Table1[Segment] = "alert", "Abandoned" )

 

JamesMoody's avatar
JamesMoody
Frequent Visitor
2 years ago

Thanks, this solved my issue!