Delete filtered rows in Power Query

S

Sgligori

New Member
Joined
May 7, 2015
Messages
46
I filtered for the negative numbers and 0s in the column "Sales".

I would like to delete those filtered rows. Is there a function in Power Query that allows me to delete this filtered data?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Best would be to turn your filter statement around by wrapping it in "not....".
This would keep the other rows.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Query filtering using Today() as a date ?
Replies
8
Views
232
alansidman
A
L
  • Solved
Power Query - filter based on cell outside table
Replies
6
Views
260
Peter_SSs
Peter_SSs
D
  • Question
Power query filter by last two months and include current month (today) + 1 week
Replies
1
Views
144
JGordon11
JGordon11
T
  • Question
Help converting Power Query that imports data to VBA
Replies
0
Views
325
The Shy Retirer
T
A
  • Question
Power Query performance question. Is it better to have 2 small tables merged or single large table?
Replies
3
Views
160
JEC
JEC

Forum statistics

Threads
1,215,312
Messages
6,124,192
Members
449,147
Latest member
sweetkt327

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top