How to delete rows that have specific values in a field?

[UsePowerBI]

Hello

How can I delete rows (by inserting the right code in the Advanced Editor) so that the rows of the table are deleted if a specific field has any of the values contained in another table's field?

Will that work when I hit refresh? As it will have to refresh the lookup table first before executing the deletion of the rows in the other table.

Thanks!

[Rocco_sprmnt21]

look a bit, it seems they have done a function just to perform this task   qui

[AlB]

Hi @UsePowerBI 

You can just use something like

Table.SelectRows(BaseTable, each <> fieldfromTheOtherTable)

to filter your base table. If you show a sample of both tables (please in text-tabular format) and include/explain the expected result we can get into the details

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers