MartyCollins
New Member
- Joined
- Jan 21, 2022
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a problem where i would like to return from a data table a list of parts that are used in several BOMs.
However i would like the include argument to take a splilled array as an input.. is this possible?
I know how to use AND/OR logic in Filter but this is a little different in that i want a dynamic list as the input.
FILTER(Data[Bill Item Name],Data[Component Name]=G27#) .. i was hoping this would work but it doesnt.. it works fine if G27 is "G27" only but then i have to drag down..
Thank you,
Martin.
I have a problem where i would like to return from a data table a list of parts that are used in several BOMs.
However i would like the include argument to take a splilled array as an input.. is this possible?
I know how to use AND/OR logic in Filter but this is a little different in that i want a dynamic list as the input.
FILTER(Data[Bill Item Name],Data[Component Name]=G27#) .. i was hoping this would work but it doesnt.. it works fine if G27 is "G27" only but then i have to drag down..
Thank you,
Martin.