Solved: Multi Column Comparison

anonymous123141 · ‎10-12-2022

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.

Anonymous · ‎10-27-2022

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

View solution in original post

Anonymous · ‎10-27-2022

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 · ‎10-12-2022

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