cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

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

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!

2 REPLIES 2
Super User II
Super User II

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

Super User III
Super User III

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 

 

SU18_powerbi_badge

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors