The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
what is the best way to have a table where i can have an exemption list but in the mcode have it look at this table to filter out all the codes that does not start with everything in this table
ive got code that does it with
each list.contains([code] = tbl_exemption_list)
how can I achieve the same this but replace with text does not start with? At the moment im having to keep adding it manually into power query
Solved! Go to Solution.
Hi, @Mahmed1
Table.SelectRows(
your_table,
(x) =>
not List.AnyTrue(
List.Transform(
exemption_list,
(t) => Text.StartsWith(x[code], t)
)
)
)
but exemption_list must be a list, not table. I hope you know how to get a list from a column of your table. And buffer this list before usage (outside of Table.SelectRows).
Thank you - ill try and give that a go
Where you put your table, do you mean refer to previous step or the exemption list table?
Thank you
the way i did it was - right click - drill doen column to change to list
that right?
basically, yes.
Hi, @Mahmed1
Table.SelectRows(
your_table,
(x) =>
not List.AnyTrue(
List.Transform(
exemption_list,
(t) => Text.StartsWith(x[code], t)
)
)
)
but exemption_list must be a list, not table. I hope you know how to get a list from a column of your table. And buffer this list before usage (outside of Table.SelectRows).