Forum Discussion

TylerVono's avatar
TylerVono
Helper III
3 years ago

Column Comparison - Vlookup

I have two columns I need to compare, one column: 'MOM Stocking Report': Shows all stocked items & 'Demand Seg': Shows the complete list of purchased items.   I need to compare them against one ano...
cardinality
Column Comparison
VLOOKUP
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi TylerVono 
Please try

Stocking Agreement? =
IF (
    ISEMPTY (
        FILTER (
            RELATEDTABLE ( 'MOM Stocking Report' ),
            'MOM Stocking Report'[Item Number] = 'Demand Seg'[ITEM NUMBER]
        )
    ),
    "YES",
    "NO"
)
  • TylerVono's avatar
    TylerVono
    Helper III
    3 years ago

    Hi There Tamerj1, I tried the equation and the same thing happens, the 'YES' result will not show up on the table, I dont think they're comparing against one another. See below, do you have any other ideas? I have a Many to Many cardinality for 'Item Number', it says there are duplicates but as you can see I removed them: