Forum Discussion
Solved
Delete Rows from a Merged Query in power query editor
Hello - I have merged 2 tables in the power query editor to create a MergedTable. I want to delete all rows in the MergedTable in which category <> "Split". I can't figure out how to do tha...
Can you select a filter from the column header (category?)
Ah, I think I understand. You managed to filter the data but you were looking for an additional process to 'complete' but the filter was the final step in the process.
It's not like the powerbi desktop data view where you can filter the data for inspection but the table is still populated with all rows.