Forum Discussion
Cross-check two tables
Hello! I have a bit of a complicated task. We have a list of spare parts, each with one or more variants. Each Variant is compatible with a certan Product. Compatibility is either tested (Yes) or i...
I don't have the column Part in the Compatibility Table.
Thied to adapt the formula for the CompatibleProducts table but the result is not the expected one
CompatibleProducts =
ADDCOLUMNS(
SUMMARIZE('Parts with Variants', 'Parts with Variants'[Part]),
"Compatible Products",
CONCATENATEX(
FILTER(
SUMMARIZE(
'Compatibility',
'Compatibility'[Variant],
'Compatibility'[Attribute],
"IsCompatible",
MAXX(
FILTER(
'Compatibility',
'Compatibility'[Value] = "Yes"
),
'Compatibility'[Attribute]
)
),
NOT(ISBLANK([IsCompatible])) // Keep only those that are compatible
),
[IsCompatible],
"; "
)
)