Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mulitple Conditions (at row level)

Hello  -   I have a situation where we have Orders that have different codes.   Sometimes just one code.   Sometimes multiple.     I would like to define a column that looks at each row, evaluating...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Can you share sample data and sample output.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

     

    A simplified example of the source data would be  (and the expected result in the last column)

     

    RMA Order #      Hdr Prob Code              Single or Multiple    

     1234A                      T1                                    Multiple

     1234A                      T2                                    Multiple

     1234A                      T3                                    Multiple

     3458A                      T1                                    Single

     

    So, in this example, because RMA Order 1234A is listed three times, each with a different Header code, this Order would be defined as "Multiple".   

     

    Order 3458A only shows up once, with one Header code, and would be defined as Single.  

     

    Does that help?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Single or Multiple Codes = IF(CALCULATE(COUNTROWS(Flu_RMAs), FILTER(Flu_RMAs, Flu_RMAs[RMA Order #] = EARLIER(Flu_RMAs[RMA Order #])),FILTER(Flu_RMAs, Flu_RMAs[Hdr Prob Code] <> EARLIER(Flu_RMAs[Hdr Prob Code]))) > 1, "Multiple", "Single")
      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        Create a new column like. Add condition to filter

        Flag = if( countX(filter(table,table[RMA Order #]=earlier(table[RMA Order #])),table[RMA Order #])>1,"Multiple","Single")