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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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
255
alansidman
A
L
  • Solved
Power Query - filter based on cell outside table
Replies
6
Views
301
Peter_SSs
Peter_SSs
M
  • Question
Best way for me to automate reports
Replies
1
Views
74
Matt Allington
M
jlhoover3
  • Solved
Power Query - Filter table column based on cell value
Replies
3
Views
117
alansidman
A
D
  • Question
Power query filter by last two months and include current month (today) + 1 week
Replies
1
Views
193
JGordon11
JGordon11

Forum statistics

Threads
1,215,947
Messages
6,127,867
Members
449,410
Latest member
adunn_23

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