Forum Discussion

anonymous123141's avatar
anonymous123141
Frequent Visitor
3 years ago
Solved

Multi Column Comparison

Hello,   I have a table with multip rows of data for "Item #'s" and I need to compare Item # with "All shipped." I want a new column, that returns a "yes" for all item numbers where there is one in...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi anonymous123141 ,

     

    Check this formula:

    Column = 
var isyes = CALCULATE(MAX('Table'[All shipped]),FILTER('Table','Table'[Item#]=EARLIER('Table'[Item#])))
return
IF(isyes = "yes","yes","no")

     

    Best Regards,

    Jay

rsbin's avatar
rsbin
Community Champion
3 years ago

anonymous123141 ,

Please try this as your [New Column]:

New Column = 
VAR _Item = [Item #]
VAR _Yes = CALCULATE( COUNTA( [All shipped] ),
                      FILTER( YourTable, YourTable[All shipped] = "YES" &&
                            [Item #] = _Item ))
RETURN
   IF( _Yes >= 1, "Yes", Blank() )

Hope this works for you.

Regards,