Multi Column Comparison

[anonymous123141]

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 instance of all shipped being yes.

[v-jayw-msft · Accepted solution]

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]

@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,