Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have 2 tables
d:
up:
in d Table
1) Split by comma and get list : Text.Split([d], ",")
2) Join whole 'up' Table at each row : each up
3) Filter up[up] column to each item inside list :
let
l = [d1]
in
Table.SelectRows([tab1], each (List.Contains(l, [up])))
but my M code filter only single/first item of list to column
I want all the items of list to filter up[up] column whichever are present.
Insert this step (modify Source appropriately)
= [a = List.Combine(List.Transform(d[d], each Text.Split(_, ", "))),
b = Table.SelectRows(Source, each List.Contains(a, [up]))][b]
I'm sorry but I can't comprehend your code, and It throws error when I applied it.
Can you please give me code more explicitly 🙏🏽