Forum Discussion

OECvargoj's avatar
OECvargoj
Frequent Visitor
8 years ago

Matching based on conditions

Hello,   I'm trying to display matching part numbers based on them having an opposite Stock Status. Using the example data below, I need a way to match Company A with Company B based on them both h...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

What exact results are you expecting?

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

OECvargoj

 

Try this column for more than 1 match

 

Column =
CONCATENATEX (
    FILTER (
        ALL ( 'Table1' ),
        Table1[Part Number] = EARLIER ( Table1[Part Number] )
            && Table1[Stock Status] <> EARLIER ( Table1[Stock Status] )
    ),
    Table1[Company],
    ", "
)