Showing results for 
Search instead for 
Did you mean: 
NovasR Occasional Visitor
Occasional Visitor

Delete rows with a specific value from my query tables

I have many tables containing equal headers, what I need is to delete the rows when this header is repeated.


In this way I would only have one MAIN header and the others would eliminate them.


Ejemplo.pngI could not filter and delete because the process must be automatable and I could not know how many times the row is repeated


The option of filtering and eliminating would not help me because in some cases the header containing the value moves a cell (variable) and that does not remove all the values ​​when filtering because I do not know which column can contain the value to I need to remove I came up with the option of placing a conditional column so that by placing the data to be deleted as an option to filter in that column and knowing which row contains the data to be repeated. Another option that probe but does not work is to use the Table.RemoveMatchingRows function in M, but it does not delete the data that I place as parameters.



CheenuSing Super Contributor
Super Contributor

Re: Delete rows with a specific value from my query tables

Hi @NovasR 


Can you upload sampledata, pbix and output expected to Google/One Drive and share the link here to find a solution.



Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,295)