Forum Discussion

ds100's avatar
ds100
Copper Contributor
Jul 11, 2022

How to Filter dynamic array with table field-to-dynamic array criteria?

Is there a way - with the Filter function or an alternative - to replicate below function but allowing for $G3# to replace $G3? FILTER(Table2[Date],(Table2[Symbol]=$G3) Thanks
Formulas and Functions
  • mtarler's avatar
    mtarler
    Jul 11, 2022

    ds100  alternatively i think you want something like this:

    =BYROW(G3#,LAMBDA(r,TEXTJOIN(", ",,TEXT(UNIQUE(FILTER(Table2[Date],(Table2[Symbol]=r),"")),"m/d"))))

    using BYROW lets you perform the operation on each row of the G3# spill 

Resources