Forum Discussion
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...
I don't know if I correctly understand your request but...
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")
Change these with your variables:
Flu_RMAs = Your table name
RMA_Order = RMA Order
Hdr Prob Code = Header Code