Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MarioCadena
Helper II
Helper II

Filter Power Query row based on 2 column values

Hi,

 

I have been trying to filter out rows that contain 2 specific values from one column each. I try to use the filter option with and as per the below formula

 

= Table.SelectRows(#"Removed Columns1", each ([Order Number] <> "PC112936" and [Invoice Date] = #date(2020, 4, 14)))

 

but instead of deleting rows when both values appear; power query is deleting them individually; so delete any [Order Number] <> "PC112936" or [Invoice Date] = #date(2020, 4, 14)

 

Could please provide some help?

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @MarioCadena 

 

If I understand it correctly, you are trying to remove rows containing [Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), select the rest rows, have a try:

 

= Table.SelectRows(#"Removed Columns1", each [ a =[Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), b = a = false][b])

 

 

View solution in original post

2 REPLIES 2
Vera_33
Resident Rockstar
Resident Rockstar

Hi @MarioCadena 

 

If I understand it correctly, you are trying to remove rows containing [Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), select the rest rows, have a try:

 

= Table.SelectRows(#"Removed Columns1", each [ a =[Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), b = a = false][b])

 

 

PhilipTreacy
Super User
Super User

Hi @MarioCadena 

Just create 2 separate filter steps?

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.