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