Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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])
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])
Hi @MarioCadena
Just create 2 separate filter steps?
Regards
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |