Help Create Rule

[sfolkes80]

I have been trying to write a rule and It is not working.  If the Series Collection contains both Number of Bowls ( Double and Single) then Yes, else no.. So if the series collection only has Single, it should flag NO.  How can I write this rule.  I am not having any luck

[sfolkes80]

Should I merge the series collection field and number of bowls? I want PQ to look at both series collection and number of bowls field

[wdx223_Daniel]

should this work.

=let a=Table.Buffer(Table.Group(PreviousStepName,"Series/Collection",{"Flag",each if List.ContainsAll([Number of Bowls],{"Double Bowl","Single Bowl"}) then "Yes" else "No"})) in Table.AddColumn(PreviousStepName,"Flag",each a{[#"Series/Collection"=[#"Series/Collection"]]}?[Flag]?)

[sfolkes80]

Thank you Daniel for looking into this for me.  So my previouse step, I merged the series collection and number of bowl, so I applied the formula and  now I am getting this error