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

 

 

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

2 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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