How do I delete specific rows from my query tables?

[bradfoster]

I have 1 million rows of data by retailer week, and I need to remove the last week of data because it was a partial week when it was loaded.  I now have a new query for last week with full data that I need to append, but I cannot figure out how to remove the partial week of data from the original query.

[v-yulgu-msft · Accepted solution]

Hi @bradfoster,

You can filter out specific rows in Query Editor mode, similar to below if there is a date field in original table.

From above example, I filtered out records where date starts from 3/21/2018 to 3/24/2018.

Regards,

Yuliana Gu

[Element115]

How would you go about filtering out, ie removing all rows but the first one for each row that belongs to a specific category?  So for instance: let's say we have 2 categories: ( cars, planes )  and let's say we have the following columns in the table: ( datetime, category ).  After sorting by datetime ascending, we want to keep the first row that shows up in the table for category 'cars', and the first row for category 'planes', deleting all the rows that come after this first row, in essence the result will be a table with 2 rows only.

How would this be done in M?

[Ena]

Keep Top Rows.