Power Query practice: Row Filtering, Deduplication & Sorting

Keep only orders from the North region. Click ▾ on the Region header and tick only North.

Keep orders with a Qty of 20 or more. Use ▾ ▸ Number Filters ▸ Greater Than Or Equal To.

Sort the orders by Qty, largest first. Use ▾ ▸ Sort Descending on the Qty header.

Sort by Region A→Z, and within each region by Qty largest first. Sort Region first, then Qty.

The SalesRaw export contains an exact duplicate order. Select all columns (Ctrl+A in the grid, or none selected) and use Home ▸ Remove Rows ▸ Remove Duplicates.